++ rg -v '#' /usr/share/zoneinfo/zone.tab ++ awk '{print $3}' ++ shuf ++ head -n1 + TZ=Africa/Mogadishu Choosen random timezone Africa/Mogadishu + echo 'Choosen random timezone Africa/Mogadishu' + ln -snf /usr/share/zoneinfo/Africa/Mogadishu /etc/localtime + echo Africa/Mogadishu + dpkg -i package_folder/clickhouse-common-static_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 49067 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-common-static (24.3.5.47.altinitystable) ... Setting up clickhouse-common-static (24.3.5.47.altinitystable) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 49096 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.3.5.47.altinitystable) ... Setting up clickhouse-common-static-dbg (24.3.5.47.altinitystable) ... + dpkg -i package_folder/clickhouse-server_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 49105 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-server (24.3.5.47.altinitystable) ... Setting up clickhouse-server (24.3.5.47.altinitystable) ... Cannot set 'net_admin' or 'ipc_lock' or 'sys_nice' or 'net_bind_service' capability for clickhouse binary. This is optional. Taskstats accounting will be disabled. To enable taskstats accounting you may add the required capability later manually. ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 49122 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-client (24.3.5.47.altinitystable) ... Setting up clickhouse-client (24.3.5.47.altinitystable) ... + echo '' + [[ -z '' ]] + ch --query 'SELECT 1' 1 + chl --query 'SELECT 1' 1 + chc --version ClickHouse client version 24.3.5.47.altinitystable (altinity build). + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /utils.lib + source /utils.lib + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper.xml /etc/clickhouse-server/config.d/ + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=30556160 + sed --follow-symlinks -i 's|[[:digit:]]\+|30556160|' /etc/clickhouse-server/config.d/keeper_port.xml + value=18851840 + sed --follow-symlinks -i 's|[[:digit:]]\+|18851840|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n '' ]] + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] x86_64 + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ Adding azure configuration + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + [[ -n '' ]] + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 minio version RELEASE.2022-01-03T18-22-58Z + wait_for_it + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=3 + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 11 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=12 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 12 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:40791 http://127.0.0.1:40791 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (40791), please use --console-address ":PORT" to choose a static port. + counter=13 + grep AccessDenied + curl --silent --verbose http://localhost:11111 AccessDeniedAccess Denied./17E49CA7D5C5F876a89b0a53-bbfe-41fc-88b5-1f729fcc3583 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 258 root 10u IPv6 39333 0t0 TCP *:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy set clickminio readwrite user=test Policy `readwrite` is set on user `test` + ./mc mb clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc policy set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio ++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio 02366_data.jsonl + for file in $(ls "${data_path}") + echo 02366_data.jsonl + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` Total: 0 B, Transferred: 0 B, Speed: 0 B/s 02731.arrow + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 76.17 MiB/s 02731.parquet + for file in $(ls "${data_path}") + echo 02731.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` Total: 0 B, Transferred: 1.57 MiB, Speed: 62.25 MiB/s + for file in $(ls "${data_path}") + echo 02876.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet clickminio/test/02876.parquet 02876.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` Total: 0 B, Transferred: 293 B, Speed: 30.64 KiB/s a.tsv + for file in $(ls "${data_path}") + echo a.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` Total: 0 B, Transferred: 24 B, Speed: 2.83 KiB/s b.tsv + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 4.30 KiB/s c.tsv + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 3.67 KiB/s + for file in $(ls "${data_path}") + echo tsv_with_header.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 4.66 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + ./setup_hdfs_minicluster.sh + ls -lha total 135M drwxr-xr-x 1 root root 4.0K Jul 22 21:32 . drwxr-xr-x 1 root root 4.0K Jul 22 21:32 .. -rw-rw-r-- 1 1000 1000 300 Jul 22 21:29 analyzer_tech_debt.txt -rw-rw-r-- 1 root root 1.6K Jun 13 06:03 attach_gdb.lib -rw-r--r-- 1 root root 1.3K Jul 22 21:32 __azurite_db_blob_extent__.json -rw-r--r-- 1 root root 3.9K Jul 22 21:32 __azurite_db_blob__.json -rw-r--r-- 1 root root 1.4K Jul 22 21:32 azurite_log lrwxrwxrwx 1 root root 7 Apr 27 05:02 bin -> usr/bin drwxr-xr-x 2 root root 4.0K Jul 22 21:32 __blobstorage__ drwxr-xr-x 2 root root 4.0K Apr 18 2022 boot drwxr-xr-x 5 root root 340 Jul 22 21:32 dev -rwxr-xr-x 1 root root 0 Jul 22 21:32 .dockerenv drwxr-xr-x 1 root root 4.0K Jul 22 21:32 etc drwxr-xr-x 10 1000 1000 4.0K Jun 15 2021 hadoop-3.3.1 drwxr-xr-x 2 root root 4.0K Apr 18 2022 home lrwxrwxrwx 1 root root 7 Apr 27 05:02 lib -> usr/lib lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Apr 27 05:02 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21M Jun 13 06:04 mc drwxr-xr-x 2 root root 4.0K Apr 27 05:02 media -rwxr-xr-x 1 root root 114M Jun 13 06:04 minio drwxr-xr-x 4 root root 4.0K Jul 22 21:33 minio_data drwxr-xr-x 2 root root 4.0K Apr 27 05:02 mnt drwxr-xr-x 2 root root 4.0K Apr 27 05:02 opt -rw-r--r-- 1 root root 0 Feb 15 01:09 .package-cache-mutate drwxrwxr-x 2 1000 1000 4.0K Jul 22 21:32 package_folder dr-xr-xr-x 529 root root 0 Jul 22 21:32 proc -rwxrwxr-x 1 root root 7.9K May 14 20:27 process_functional_tests_result.py drwx------ 1 root root 4.0K Jul 22 21:33 root drwxr-xr-x 1 root root 4.0K Jul 22 21:32 run -rwxrwxr-x 1 root root 16K Jun 13 06:03 run.sh lrwxrwxrwx 1 root root 8 Apr 27 05:02 sbin -> usr/sbin -rwxrwxr-x 1 root root 11K May 14 20:27 setup_export_logs.sh -rwxrwxr-x 1 root root 351 Jun 13 06:03 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3.4K Jun 13 06:03 setup_minio.sh drwxr-xr-x 2 root root 4.0K Apr 27 05:02 srv -rw-rw-r-- 1 root root 13K Jun 13 06:03 stress_tests.lib dr-xr-xr-x 13 root root 0 Jul 22 21:32 sys drwxrwxr-x 2 1000 1000 4.0K Jul 22 21:32 test_output drwxrwxrwt 1 root root 4.0K Jul 22 21:32 tmp drwxr-xr-x 1 root root 4.0K Apr 27 05:02 usr -rw-rw-r-- 1 root root 833 Jun 13 06:03 utils.lib drwxr-xr-x 1 root root 4.0K Apr 27 05:05 var + cd hadoop-3.3.1 + export JAVA_HOME=/usr + JAVA_HOME=/usr + mkdir -p target/test/data + chown clickhouse ./target/test/data + nc -z localhost 12222 + sudo -E -u clickhouse bin/mapred minicluster -format -nomr -nnport 12222 + sleep 1 + nc -z localhost 12222 + sleep 1 + nc -z localhost 12222 + lsof -i :12222 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME java 550 clickhouse 322u IPv4 50329 0t0 TCP localhost:12222 (LISTEN) + sleep 5 + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + [[ -n '' ]] + '[' 1 -gt 1 ']' + sudo clickhouse start chown -R clickhouse: '/var/run/clickhouse-server/' Will run sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon Waiting for server to start Waiting for server to start Server started + [[ -n '' ]] + for _ in {1..100} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..100} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..100} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..100} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..100} + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "PUT /devstoreaccount1/cont/lmtmrwqepnrgxpggecoqtbdzyecesegl?blockid=ormxuootxobmrncszgjnwhifynnuoypvmdgwlybnuzriinhxbfxsflmdlssmault&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "PUT /devstoreaccount1/cont/lmtmrwqepnrgxpggecoqtbdzyecesegl?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "GET /devstoreaccount1/cont/lmtmrwqepnrgxpggecoqtbdzyecesegl HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "GET /devstoreaccount1/cont/lmtmrwqepnrgxpggecoqtbdzyecesegl HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:18:33:42 +0000] "DELETE /devstoreaccount1/cont/lmtmrwqepnrgxpggecoqtbdzyecesegl HTTP/1.1" 202 - 1 + break + setup_logs_replication File /tmp/export-logs-config.sh does not exist, do not setup + set +x + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 738 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ aehxB =~ e ]] + set_e=true + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + true + set -e + return + export -f run_tests + '[' 1 -gt 1 ']' + timeout_with_logging 9720 bash -c run_tests + local exit_code=0 + timeout 9720 bash -c run_tests + read -ra ADDITIONAL_OPTIONS + HIGH_LEVEL_COVERAGE=YES + '[' 1 -gt 1 ']' + [[ -n '' ]] + [[ -n '' ]] ++ clickhouse-client --query 'SELECT value LIKE '\''%SANITIZE_COVERAGE%'\'' FROM system.build_options WHERE name = '\''CXX_FLAGS'\''' + [[ 1 == 0 ]] + ADDITIONAL_OPTIONS+=('--jobs') + ADDITIONAL_OPTIONS+=('8') + [[ -n 3 ]] + [[ -n 5 ]] + ADDITIONAL_OPTIONS+=('--run-by-hash-num') + ADDITIONAL_OPTIONS+=("$RUN_BY_HASH_NUM") + ADDITIONAL_OPTIONS+=('--run-by-hash-total') + ADDITIONAL_OPTIONS+=("$RUN_BY_HASH_TOTAL") + HIGH_LEVEL_COVERAGE=NO + [[ -n '' ]] + [[ NO = \Y\E\S ]] + ADDITIONAL_OPTIONS+=('--report-logs-stats') + try_run_with_retry 10 clickhouse-client -q 'insert into system.zookeeper (name, path, value) values ('\''auxiliary_zookeeper2'\'', '\''/test/chroot/'\'', '\'''\'')' + local total_retries=10 + shift + fn_exists run_with_retry + declare -F run_with_retry + run_with_retry 10 clickhouse-client -q 'insert into system.zookeeper (name, path, value) values ('\''auxiliary_zookeeper2'\'', '\''/test/chroot/'\'', '\'''\'')' + [[ hxBc =~ e ]] + set_e=false + set +e + local total_retries=10 + shift + local retry=0 + '[' 0 -ge 10 ']' + clickhouse-client -q 'insert into system.zookeeper (name, path, value) values ('\''auxiliary_zookeeper2'\'', '\''/test/chroot/'\'', '\'''\'')' + false + return + set +e + clickhouse-test --testname --shard --zookeeper --check-zookeeper-session --hung-check --print-time --test-runs 1 --hung-check --print-time --jobs 8 --run-by-hash-num 3 --run-by-hash-total 5 --report-logs-stats + ts '%Y-%m-%d %H:%M:%S' + tee -a test_output/test_result.txt 2024-07-22 21:35:17 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-07-22 21:35:17 Connecting to ClickHouse server... OK 2024-07-22 21:35:17 Connected to server 24.3.5.47.altinitystable @ b6642564dbf296d6e55b907d7af6c8087470b672 HEAD 2024-07-22 21:35:17 Found 1109 parallel tests and 117 sequential tests 2024-07-22 21:35:21 2024-07-22 21:35:21 Running about 138 stateless tests (ForkPoolWorker-2). 2024-07-22 21:35:21 2024-07-22 21:35:21 03196_max_intersections_arena_crash: [ OK ] 3.59 sec. 2024-07-22 21:35:21 2024-07-22 21:35:21 Running about 138 stateless tests (ForkPoolWorker-5). 2024-07-22 21:35:21 2024-07-22 21:35:21 03151_analyzer_view_read_only_necessary_columns: [ OK ] 3.68 sec. 2024-07-22 21:35:21 2024-07-22 21:35:21 Running about 138 stateless tests (ForkPoolWorker-6). 2024-07-22 21:35:21 2024-07-22 21:35:21 03127_argMin_combinator_state: [ OK ] 3.74 sec. 2024-07-22 21:35:21 2024-07-22 21:35:21 Running about 138 stateless tests (ForkPoolWorker-4). 2024-07-22 21:35:21 2024-07-22 21:35:21 03143_parallel_replicas_mat_view_bug: [ OK ] 3.84 sec. 2024-07-22 21:35:22 2024-07-22 21:35:22 Running about 138 stateless tests (ForkPoolWorker-3). 2024-07-22 21:35:22 2024-07-22 21:35:22 03151_redundant_distinct_with_window: [ OK ] 4.34 sec. 2024-07-22 21:35:22 2024-07-22 21:35:22 Running about 138 stateless tests (ForkPoolWorker-7). 2024-07-22 21:35:22 2024-07-22 21:35:22 03130_abs_in_key_condition_bug: [ OK ] 4.40 sec. 2024-07-22 21:35:22 2024-07-22 21:35:22 Running about 138 stateless tests (ForkPoolWorker-9). 2024-07-22 21:35:22 2024-07-22 21:35:22 03023_group_by_use_nulls_analyzer_crashes: [ OK ] 4.72 sec. 2024-07-22 21:35:24 2024-07-22 21:35:24 Running about 138 stateless tests (ForkPoolWorker-8). 2024-07-22 21:35:24 2024-07-22 21:35:24 03033_scalars_context_data_race: [ OK ] 6.66 sec. 2024-07-22 21:35:24 03015_with_fill_invalid_expression: [ OK ] 3.29 sec. 2024-07-22 21:35:25 03016_analyzer_groupby_fuzz_59796: [ OK ] 3.64 sec. 2024-07-22 21:35:25 03015_analyzer_groupby_fuzz_60772: [ OK ] 3.48 sec. 2024-07-22 21:35:25 03022_alter_materialized_view_query_has_inner_table: [ OK ] 3.94 sec. 2024-07-22 21:35:25 03014_window_view_crash: [ OK ] 3.34 sec. 2024-07-22 21:35:25 03014_analyzer_groupby_fuzz_60317: [ OK ] 3.50 sec. 2024-07-22 21:35:26 03014_group_by_use_nulls_injective_functions_and_analyzer: [ OK ] 3.71 sec. 2024-07-22 21:35:28 03013_position_const_start_pos: [ OK ] 3.49 sec. 2024-07-22 21:35:28 03006_analyzer_executable_table_function: [ OK ] 3.16 sec. 2024-07-22 21:35:28 03008_groupSortedArray_field: [ OK ] 3.41 sec. 2024-07-22 21:35:28 03003_sql_json_nonsense: [ OK ] 3.17 sec. 2024-07-22 21:35:28 03004_json_named_tuples_inference_ambiguous_paths_as_string: [ OK ] 3.33 sec. 2024-07-22 21:35:29 03003_compatibility_setting_bad_value: [ OK ] 3.05 sec. 2024-07-22 21:35:31 03002_modify_query_cte: [ OK ] 3.07 sec. 2024-07-22 21:35:31 03009_format_show_database: [ OK ] 6.84 sec. 2024-07-22 21:35:32 03000_virtual_columns_in_prewhere: [ OK ] 3.69 sec. 2024-07-22 21:35:32 03002_analyzer_prewhere: [ OK ] 4.32 sec. 2024-07-22 21:35:32 02998_primary_key_skip_columns: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:35:33 03008_optimize_equal_ranges: [ OK ] 7.95 sec. 2024-07-22 21:35:33 02999_scalar_subqueries_bug_1: [ OK ] 3.88 sec. 2024-07-22 21:35:33 03001_insert_threads_deduplication: [ OK ] 4.73 sec. 2024-07-22 21:35:34 02999_scalar_subqueries_bug_2: [ OK ] 3.33 sec. 2024-07-22 21:35:35 02998_system_dns_cache_table: [ OK ] 3.35 sec. 2024-07-22 21:35:36 02998_ipv6_hashing: [ OK ] 3.42 sec. 2024-07-22 21:35:36 03001_bad_error_message_higher_order_functions: [ OK ] 7.38 sec. 2024-07-22 21:35:36 02998_attach_partition_not_allowed_if_structure_differs_due_to_materialized_column: [ OK ] 3.55 sec. 2024-07-22 21:35:36 02996_index_compaction_counterexample: [ OK ] 3.54 sec. 2024-07-22 21:35:38 02993_values_escape_quote: [ OK ] 3.52 sec. 2024-07-22 21:35:39 02990_arrayFold_nullable_lc: [ OK ] 4.36 sec. 2024-07-22 21:35:40 02990_optimize_uniq_to_count_alias: [ OK ] 3.84 sec. 2024-07-22 21:35:40 02990_parts_splitter_invalid_ranges: [ OK ] 3.66 sec. 2024-07-22 21:35:40 02997_fix_datetime64_scale_conversion: [ OK ] 7.60 sec. 2024-07-22 21:35:41 02985_dialects_with_distributed_tables: [ OK ] 4.41 sec. 2024-07-22 21:35:42 02983_empty_map: [ OK ] 4.46 sec. 2024-07-22 21:35:42 02981_translate_fixedstring: [ OK ] 3.34 sec. 2024-07-22 21:35:43 02973_analyzer_join_use_nulls_column_not_found: [ OK ] 3.71 sec. 2024-07-22 21:35:44 02973_dictionary_table_exception_fix: [ OK ] 3.31 sec. 2024-07-22 21:35:44 02985_parser_check_stack_size: [ OK ] 7.57 sec. 2024-07-22 21:35:44 02969_functions_to_subcolumns_if_null: [ OK ] 3.74 sec. 2024-07-22 21:35:46 02969_analyzer_eliminate_injective_functions: [ OK ] 3.63 sec. 2024-07-22 21:35:48 02968_mysql_prefer_column_name_to_alias: [ OK ] 4.03 sec. 2024-07-22 21:35:48 02995_forget_partition: [ OK ] 15.05 sec. 2024-07-22 21:35:48 02967_analyzer_fuzz: [ OK ] 3.69 sec. 2024-07-22 21:35:48 02969_archive_seek: [ OK ] 5.79 sec. 2024-07-22 21:35:49 02963_invalid_identifier: [ OK ] 3.17 sec. 2024-07-22 21:35:50 02980_s3_plain_DROP_TABLE_MergeTree: [ OK ] 10.81 sec. 2024-07-22 21:35:52 02952_archive_parsing: [ OK ] 3.18 sec. 2024-07-22 21:35:52 02956_fix_to_start_of_milli_microsecond: [ OK ] 3.52 sec. 2024-07-22 21:35:52 02952_binary: [ OK ] 3.92 sec. 2024-07-22 21:35:53 02956_clickhouse_local_system_parts: [ OK ] 5.42 sec. 2024-07-22 21:35:55 02945_blake3_msan: [ OK ] 3.35 sec. 2024-07-22 21:35:55 02943_variant_type_with_different_local_and_global_order: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:35:55 02949_parallel_replicas_in_subquery: [ OK ] 4.91 sec. 2024-07-22 21:35:56 02950_part_log_bytes_uncompressed: [ OK ] 7.13 sec. 2024-07-22 21:35:57 02946_format_values: [ OK ] 5.03 sec. 2024-07-22 21:35:57 02943_tokenbf_and_ngrambf_indexes_support_match_function: [ OK ] 4.89 sec. 2024-07-22 21:35:58 02943_create_query_interpreter_sample_block_fix: [ OK ] 4.67 sec. 2024-07-22 21:36:00 02935_date_trunc_case_unsensitiveness: [ OK ] 3.97 sec. 2024-07-22 21:36:00 02935_ipv6_bit_operations: [ OK ] 3.88 sec. 2024-07-22 21:36:01 02943_order_by_all: [ OK ] 5.97 sec. 2024-07-22 21:36:04 02931_ubsan_error_arena_aligned_alloc: [ OK ] 3.57 sec. 2024-07-22 21:36:06 02922_respect_nulls_parser: [ OK ] 4.63 sec. 2024-07-22 21:36:06 02940_variant_text_deserialization: [ OK ] 10.27 sec. 2024-07-22 21:36:06 02931_size_virtual_column_use_structure_from_insertion_table: [ OK ] 5.70 sec. 2024-07-22 21:36:07 02931_file_cluster: [ OK ] 8.42 sec. 2024-07-22 21:36:08 02920_unary_operators_functions: [ OK ] 3.56 sec. 2024-07-22 21:36:08 02968_file_log_multiple_read: [ OK ] 24.75 sec. 2024-07-22 21:36:11 02920_alter_column_of_projections: [ OK ] 4.75 sec. 2024-07-22 21:36:11 02918_join_pm_lc_crash: [ OK ] 3.81 sec. 2024-07-22 21:36:12 02918_parallel_replicas_custom_key_unavailable_replica: [ OK ] 5.77 sec. 2024-07-22 21:36:15 02920_capnp_protobuf_auto_schema_nested: [ OK ] 9.64 sec. 2024-07-22 21:36:17 02911_join_on_nullsafe_optimization: [ OK ] 5.15 sec. 2024-07-22 21:36:17 02918_sqlite_path_check: [ OK ] 11.13 sec. 2024-07-22 21:36:18 02910_replicated_merge_parameters_must_consistent: [ OK ] 4.94 sec. 2024-07-22 21:36:18 02915_input_table_function_in_subquery: [ OK ] 9.58 sec. 2024-07-22 21:36:20 02907_http_exception_json_bug: [ OK ] 4.45 sec. 2024-07-22 21:36:21 02911_analyzer_order_by_read_in_order_query_plan: [ OK ] 10.13 sec. 2024-07-22 21:36:21 02907_read_buffer_content_is_cached_multiple_blobs: [ OK ] 4.28 sec. 2024-07-22 21:36:21 02906_flatten_only_true_nested: [ OK ] 3.86 sec. 2024-07-22 21:36:22 02905_show_setting_query: [ OK ] 3.71 sec. 2024-07-22 21:36:23 02932_kill_query_sleep: [ OK ] 25.57 sec. 2024-07-22 21:36:25 02902_select_subcolumns_from_engine_null: [ OK ] 3.92 sec. 2024-07-22 21:36:25 02905_system_logs_hostname: [ OK ] 7.52 sec. 2024-07-22 21:36:26 02896_optimize_array_exists_to_has_with_date: [ OK ] 3.25 sec. 2024-07-22 21:36:26 02900_date_time_check_overflow: [ OK ] 4.82 sec. 2024-07-22 21:36:28 02893_trash_optimization: [ OK ] 3.43 sec. 2024-07-22 21:36:29 02892_SummingMergeTree_Nested: [ OK ] 3.86 sec. 2024-07-22 21:36:30 02892_rocksdb_trivial_count: [ OK ] 3.85 sec. 2024-07-22 21:36:30 02891_alter_update_adaptive_granularity: [ OK ] 3.81 sec. 2024-07-22 21:36:33 02967_parallel_replicas_join_algo_and_analyzer: [ OK ] 48.72 sec. 2024-07-22 21:36:33 02890_partition_prune_in_extra_columns: [ OK ] 3.63 sec. 2024-07-22 21:36:33 02891_rename_table_without_keyword: [ OK ] 4.54 sec. 2024-07-22 21:36:34 02905_csv_unquoted_string_with_cr: [ OK ] 13.69 sec. 2024-07-22 21:36:34 02890_untuple_column_names: [ OK ] 4.35 sec. 2024-07-22 21:36:34 02884_parallel_window_functions: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:36:35 02898_input_format_values_allow_data_after_semicolon: [ OK ] 13.46 sec. 2024-07-22 21:36:36 02885_create_distributed_table_without_as: [ OK ] 2.90 sec. 2024-07-22 21:36:36 02888_single_state_nullable_type: [ OK ] 3.43 sec. 2024-07-22 21:36:36 02888_obsolete_settings: [ OK ] 3.54 sec. 2024-07-22 21:36:37 02884_duplicate_index_name: [ OK ] 3.14 sec. 2024-07-22 21:36:37 02903_client_insert_in_background: [ OK ] 16.34 sec. 2024-07-22 21:36:38 02881_system_detached_parts_modification_time: [ OK ] 4.00 sec. 2024-07-22 21:36:40 02874_infer_objects_as_named_tuples: [ OK ] 3.75 sec. 2024-07-22 21:36:40 02871_multiple_joins_rewriter_v2_handle_last_table_columns: [ OK ] 3.54 sec. 2024-07-22 21:36:41 02875_fix_column_decimal_serialization: [ OK ] 4.50 sec. 2024-07-22 21:36:42 02878_use_structure_from_insertion_table_with_explicit_insert_columns: [ OK ] 6.53 sec. 2024-07-22 21:36:42 02869_unicode_minus: [ OK ] 3.23 sec. 2024-07-22 21:36:42 02869_parallel_replicas_read_from_several: [ OK ] 4.90 sec. 2024-07-22 21:36:44 02863_non_const_timezone_check: [ OK ] 4.15 sec. 2024-07-22 21:36:46 02840_grace_hash_join_structure_mismatch: [ OK ] 3.54 sec. 2024-07-22 21:36:46 02842_move_pk_to_end_of_prewhere: [ OK ] 4.68 sec. 2024-07-22 21:36:47 02842_table_function_file_filter_by_virtual_columns: [ OK ] 6.51 sec. 2024-07-22 21:36:48 02842_mutations_replace_non_deterministic: [ OK ] 7.27 sec. 2024-07-22 21:36:50 02836_file_diagnostics_while_reading_header: [ OK ] 5.61 sec. 2024-07-22 21:36:50 02834_add_sub_date_functions: [ OK ] 4.17 sec. 2024-07-22 21:36:51 02832_integer_type_inference: [ OK ] 3.62 sec. 2024-07-22 21:36:51 02833_tuple_concat: [ OK ] 4.36 sec. 2024-07-22 21:36:53 02831_trash: [ OK ] 3.23 sec. 2024-07-22 21:36:54 02832_transform_fixed_string_no_default: [ OK ] 3.42 sec. 2024-07-22 21:36:55 02818_parameterized_view_with_cte_multiple_usage: [ OK ] 3.60 sec. 2024-07-22 21:36:55 02831_regexp_analyze_recursion: [ OK ] 3.73 sec. 2024-07-22 21:36:57 02815_logical_error_cannot_get_column_name_of_set: [ OK ] 3.29 sec. 2024-07-22 21:36:58 02814_create_index_uniq_noop: [ OK ] 3.06 sec. 2024-07-22 21:36:59 02814_order_by_tuple_window_function: [ OK ] 3.36 sec. 2024-07-22 21:37:00 02889_file_log_save_errors: [ OK ] 29.55 sec. 2024-07-22 21:37:00 02815_join_algorithm_setting: [ OK ] 6.60 sec. 2024-07-22 21:37:02 02813_any_value: [ OK ] 3.42 sec. 2024-07-22 21:37:02 02813_array_concat_agg: [ OK ] 3.60 sec. 2024-07-22 21:37:03 02812_csv_date_time_with_comma: [ OK ] 3.40 sec. 2024-07-22 21:37:04 02814_currentDatabase_for_table_functions: [ OK ] 6.55 sec. 2024-07-22 21:37:04 02812_large_varints: [ OK ] 3.46 sec. 2024-07-22 21:37:05 02841_not_ready_set_bug: [ OK ] 23.06 sec. 2024-07-22 21:37:06 02810_system_jemalloc_bins: [ OK ] 4.03 sec. 2024-07-22 21:37:06 02810_fix_remove_dedundant_distinct_view: [ OK ] 3.77 sec. 2024-07-22 21:37:07 02810_convert_uuid_to_uint128: [ OK ] 3.57 sec. 2024-07-22 21:37:07 02808_aliases_inside_case: [ OK ] 3.37 sec. 2024-07-22 21:37:09 02809_has_subsequence: [ OK ] 4.95 sec. 2024-07-22 21:37:09 02802_with_cube_with_totals: [ OK ] 3.53 sec. 2024-07-22 21:37:10 02801_transform_nullable: [ OK ] 3.80 sec. 2024-07-22 21:37:10 02872_null_as_default_nested: [ OK ] 33.67 sec. 2024-07-22 21:37:12 02795_full_join_assert_cast: [ OK ] 3.26 sec. 2024-07-22 21:37:12 02800_clickhouse_local_default_settings: [ OK ] 5.23 sec. 2024-07-22 21:37:13 02791_predicate_pushdown_different_types: [ OK ] 3.47 sec. 2024-07-22 21:37:13 02798_substring_index: [ OK ] 6.22 sec. 2024-07-22 21:37:13 02790_fix_coredump_when_compile_expression: [ OK ] 3.43 sec. 2024-07-22 21:37:14 02789_functions_after_sorting_and_columns_with_same_names_bug_2: [ OK ] 3.87 sec. 2024-07-22 21:37:15 02806_system_parts_columns_modification_time: [ OK ] 9.90 sec. 2024-07-22 21:37:15 02789_jit_cannot_convert_column: [ OK ] 3.49 sec. 2024-07-22 21:37:16 02785_global_join_too_many_columns: [ OK ] 4.21 sec. 2024-07-22 21:37:16 02784_move_all_conditions_to_prewhere_analyzer_asan: [ OK ] 3.62 sec. 2024-07-22 21:37:17 02783_max_bytes_to_read_in_schema_inference: [ OK ] 3.56 sec. 2024-07-22 21:37:18 02781_data_skipping_index_merge_tree_min_for_seek: [ OK ] 2.46 sec. 2024-07-22 21:37:18 02783_parsedatetimebesteffort_syslog: [ OK ] 3.57 sec. 2024-07-22 21:37:20 02771_jit_functions_comparison_crash: [ OK ] 3.87 sec. 2024-07-22 21:37:20 02752_is_null_priority: [ OK ] 3.35 sec. 2024-07-22 21:37:23 02740_hashed_dictionary_load_factor_smoke: [ OK ] 5.18 sec. 2024-07-22 21:37:24 02767_into_outfile_extensions_msan: [ OK ] 7.25 sec. 2024-07-22 21:37:24 02735_array_map_array_of_tuples: [ OK ] 3.53 sec. 2024-07-22 21:37:25 02752_forbidden_headers: [ OK ] 6.95 sec. 2024-07-22 21:37:25 02737_session_timezone: [ OK ] 4.96 sec. 2024-07-22 21:37:28 02717_pretty_json: [ OK ] 3.45 sec. 2024-07-22 21:37:28 02715_or_null: [ OK ] 3.66 sec. 2024-07-22 21:37:29 02711_trim_aliases: [ OK ] 3.40 sec. 2024-07-22 21:37:31 02710_date_diff_aliases: [ OK ] 3.35 sec. 2024-07-22 21:37:31 02722_matcher_join_use_nulls: [ OK ] 7.98 sec. 2024-07-22 21:37:32 02710_topk_with_empty_array: [ OK ] 3.33 sec. 2024-07-22 21:37:34 02708_dotProduct: [ OK ] 5.71 sec. 2024-07-22 21:37:36 02707_keeper_map_delete_update_strict: [ OK ] 4.64 sec. 2024-07-22 21:37:37 02706_kolmogorov_smirnov_test: [ OK ] 6.35 sec. 2024-07-22 21:37:39 02704_storage_merge_explain_graph_crash: [ OK ] 3.75 sec. 2024-07-22 21:37:41 02700_regexp_operator: [ OK ] 3.37 sec. 2024-07-22 21:37:43 02699_polygons_sym_difference_total_analyzer: [ OK ] 3.41 sec. 2024-07-22 21:37:44 02718_cli_dashed_options_parsing: [ OK ] 20.41 sec. 2024-07-22 21:37:44 02698_marked_dropped_tables: [ OK ] 3.53 sec. 2024-07-22 21:37:45 02771_system_user_processes: [ OK ] 29.42 sec. 2024-07-22 21:37:46 02694_wrong_identifier_shouldnt_be_accepted: [ OK ] 3.50 sec. 2024-07-22 21:37:48 02693_multiple_joins_in: [ OK ] 3.30 sec. 2024-07-22 21:37:48 02692_multiple_joins_unicode: [ OK ] 3.85 sec. 2024-07-22 21:37:49 02691_multiple_joins_backtick_identifiers: [ OK ] 3.81 sec. 2024-07-22 21:37:49 02704_max_backup_bandwidth: [ OK ] 17.04 sec. 2024-07-22 21:37:50 02689_meaningless_data_types: [ OK ] 3.31 sec. 2024-07-22 21:37:51 02688_long_aggregate_function_names: [ OK ] 3.17 sec. 2024-07-22 21:37:51 02681_aggregation_by_partitions_bug: [ OK ] 3.08 sec. 2024-07-22 21:37:52 02675_is_ipv6_function_fix: [ OK ] 3.35 sec. 2024-07-22 21:37:52 02677_get_subcolumn_array_of_tuples: [ OK ] 3.63 sec. 2024-07-22 21:37:53 02674_null_default_structure: [ OK ] 3.26 sec. 2024-07-22 21:37:55 02668_column_block_number_vertical_merge: [ OK ] 4.22 sec. 2024-07-22 21:37:57 02597_column_update_and_replication: [ OK ] 5.06 sec. 2024-07-22 21:37:59 02834_remote_session_log: [ OK ] 72.55 sec. 2024-07-22 21:38:01 02581_width_bucket: [ OK ] 5.46 sec. 2024-07-22 21:38:01 02577_analyzer_array_join_calc_twice: [ OK ] 3.55 sec. 2024-07-22 21:38:03 02575_merge_prewhere_default_expression: [ OK ] 3.90 sec. 2024-07-22 21:38:05 02575_merge_prewhere_ephemeral: [ OK ] 3.90 sec. 2024-07-22 21:38:05 02573_insert_null_as_default_null_as_empty_nested: [ OK ] 4.31 sec. 2024-07-22 21:38:09 02568_and_consistency: [ OK ] 3.97 sec. 2024-07-22 21:38:13 02572_materialized_views_ignore_errors: [ OK ] 8.05 sec. 2024-07-22 21:38:13 02568_json_array_length: [ OK ] 3.77 sec. 2024-07-22 21:38:16 02572_query_views_log_background_thread: [ OK ] 12.81 sec. 2024-07-22 21:38:17 02566_analyzer_limit_settings_distributed: [ OK ] 4.13 sec. 2024-07-22 21:38:20 02561_with_fill_date_datetime_incompatible: [ OK ] 3.25 sec. 2024-07-22 21:38:24 02560_count_digits: [ OK ] 3.79 sec. 2024-07-22 21:38:30 02560_regexp_denial_of_service: [ OK ] 5.57 sec. 2024-07-22 21:38:33 02563_arrow_low_cardinality_bug: [ OK ] 20.06 sec. 2024-07-22 21:38:39 02556_local_with_totals_and_extremes: [ OK ] 5.24 sec. 2024-07-22 21:38:40 02590_interserver_mode_client_info_initial_query_start_time: [ OK ] 46.55 sec. 2024-07-22 21:38:41 02704_keeper_map_zk_nodes: [ OK ] 66.70 sec. 2024-07-22 21:38:41 02784_connection_string: [ OK ] 87.81 sec. 2024-07-22 21:38:42 02558_system_processes_elapsed: [ OK ] 12.38 sec. 2024-07-22 21:38:42 02553_type_object_analyzer: [ OK ] 3.55 sec. 2024-07-22 21:38:43 02552_regression_crash: [ OK ] 3.44 sec. 2024-07-22 21:38:45 02552_client_format_settings: [ OK ] 3.44 sec. 2024-07-22 21:38:45 02542_table_function_format: [ OK ] 3.76 sec. 2024-07-22 21:38:46 02534_s3_heap_use_after_free: [ OK ] 3.53 sec. 2024-07-22 21:38:48 02534_join_prewhere_bug: [ OK ] 4.25 sec. 2024-07-22 21:38:49 02530_ip_part_id: [ OK ] 3.92 sec. 2024-07-22 21:38:49 02532_analyzer_aggregation_with_rollup: [ OK ] 4.65 sec. 2024-07-22 21:38:50 02525_different_engines_in_temporary_tables: [ OK ] 4.07 sec. 2024-07-22 21:38:52 02539_vertical_merge_compact_parts: [ OK ] 10.15 sec. 2024-07-22 21:38:52 02521_analyzer_aggregation_without_column: [ OK ] 3.51 sec. 2024-07-22 21:38:53 02521_grouping_sets_plus_memory_efficient_aggr: [ OK ] 3.59 sec. 2024-07-22 21:38:53 02523_array_shuffle: [ OK ] 5.78 sec. 2024-07-22 21:38:56 02517_uuid_parsing: [ OK ] 3.50 sec. 2024-07-22 21:38:57 02516_projections_and_context: [ OK ] 3.92 sec. 2024-07-22 21:38:57 02515_projections_with_totals: [ OK ] 3.54 sec. 2024-07-22 21:38:58 02518_parquet_arrow_orc_boolean_value: [ OK ] 8.13 sec. 2024-07-22 21:38:59 02514_bad_index_granularity: [ OK ] 3.22 sec. 2024-07-22 21:39:01 02512_array_join_name_resolution: [ OK ] 3.54 sec. 2024-07-22 21:39:01 02513_prewhere_combine_step_filters: [ OK ] 4.11 sec. 2024-07-22 21:39:02 02508_index_analysis_to_date_timezone: [ OK ] 3.93 sec. 2024-07-22 21:39:02 02504_parse_datetime_best_effort_calebeaires: [ OK ] 3.43 sec. 2024-07-22 21:39:04 02503_mysql_compat_utc_timestamp: [ OK ] 3.40 sec. 2024-07-22 21:39:05 02503_bad_compatibility_setting: [ OK ] 3.56 sec. 2024-07-22 21:39:06 02501_analyzer_expired_context_crash_fix: [ OK ] 3.64 sec. 2024-07-22 21:39:06 02500_analyzer_storage_view_crash_fix: [ OK ] 3.78 sec. 2024-07-22 21:39:07 02561_temporary_table_grants: [ OK ] 51.01 sec. 2024-07-22 21:39:08 02499_quantile_nan_ubsan_msan: [ OK ] 4.13 sec. 2024-07-22 21:39:08 02498_analyzer_settings_push_down: [ OK ] 3.87 sec. 2024-07-22 21:39:10 02497_source_part_is_intact_when_mutation: [ OK ] 3.99 sec. 2024-07-22 21:39:11 02517_infer_uint64_in_case_of_int64_overflow: [ OK ] 19.05 sec. 2024-07-22 21:39:12 02494_array_function_range: [ OK ] 3.65 sec. 2024-07-22 21:39:12 02487_create_index_normalize_functions: [ OK ] 3.42 sec. 2024-07-22 21:39:12 02495_concat_with_separator: [ OK ] 5.58 sec. 2024-07-22 21:39:14 02482_execute_functions_before_sorting_bug: [ OK ] 3.78 sec. 2024-07-22 21:39:15 02481_xxh3_hash_function: [ OK ] 3.33 sec. 2024-07-22 21:39:16 02481_analyzer_optimize_grouping_sets_keys: [ OK ] 3.54 sec. 2024-07-22 21:39:16 02481_merge_array_join_sample_by: [ OK ] 4.14 sec. 2024-07-22 21:39:19 02482_value_block_parsing: [ OK ] 7.22 sec. 2024-07-22 21:39:20 02478_projection_and_alter_low_cardinality: [ OK ] 3.70 sec. 2024-07-22 21:39:22 02477_is_null_parser: [ OK ] 3.27 sec. 2024-07-22 21:39:24 02473_map_element_nullable: [ OK ] 4.16 sec. 2024-07-22 21:39:26 02471_wrong_date_monotonicity: [ OK ] 3.50 sec. 2024-07-22 21:39:27 02480_tets_show_full: [ OK ] 11.15 sec. 2024-07-22 21:39:28 02467_cross_join_three_table_functions: [ OK ] 3.45 sec. 2024-07-22 21:39:30 02466_distributed_query_profiler: [ OK ] 4.03 sec. 2024-07-22 21:39:30 02463_julian_day_ubsan: [ OK ] 3.17 sec. 2024-07-22 21:39:32 02462_distributions: [ OK ] 4.77 sec. 2024-07-22 21:39:34 02456_BLAKE3_hash_function_test: [ OK ] 3.35 sec. 2024-07-22 21:39:34 02457_parse_date_time_best_effort: [ OK ] 4.16 sec. 2024-07-22 21:39:36 02456_summing_mt_lc: [ OK ] 3.73 sec. 2024-07-22 21:39:38 02456_alter-nullable-column-bag-2: [ OK ] 3.90 sec. 2024-07-22 21:39:38 02456_test_zero_copy_mutation: [ OK ] 4.07 sec. 2024-07-22 21:39:38 02481_parquet_int_list_multiple_chunks: [ OK ] 23.04 sec. 2024-07-22 21:39:40 02455_count_state_asterisk: [ OK ] 3.72 sec. 2024-07-22 21:39:41 02454_create_table_with_custom_disk: [ OK ] 3.10 sec. 2024-07-22 21:39:42 02454_compressed_marks_in_compact_part: [ OK ] 3.59 sec. 2024-07-22 21:39:43 02452_check_low_cardinality: [ OK ] 4.19 sec. 2024-07-22 21:39:46 02451_variadic_null_garbage_data: [ FAIL ] 5.05 sec. - return code: 241 2024-07-22 21:39:46 [cd337481d243] 2024.07.22 11:39:45.480000 [ 3790 ] {c58f1c69-a898-4360-bda5-24b222d16f5d} executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.96 GiB (attempt to allocate chunk of 0 bytes), maximum: 27.54 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: While executing AggregatingTransform. (MEMORY_LIMIT_EXCEEDED) (version 24.3.5.47.altinitystable (altinity build)) (from [::1]:51296) (comment: 02451_variadic_null_garbage_data.sql) (in query: SELECT argMaxIf((n, n), n, n % 5 == 0) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50));), Stack trace (when copying this message, always include the lines below): 2024-07-22 21:39:46 2024-07-22 21:39:46 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000000a8ef122 2024-07-22 21:39:46 1. /build/contrib/llvm-project/libcxx/include/exception:116: std::exception::exception[abi:v15000]() @ 0x000000000a8ef0ed 2024-07-22 21:39:46 2. /build/base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x00000000229d6ac0 2024-07-22 21:39:46 3. /build/src/Common/Exception.cpp:94: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000132ad8ce 2024-07-22 21:39:46 4. /build/src/Common/Exception.h:90: DB::Exception::Exception(String&&, int, bool) @ 0x000000000a8e5cca 2024-07-22 21:39:46 5. /build/src/Common/Exception.h:109: DB::Exception::Exception>>(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view>&&) @ 0x00000000132dd69d 2024-07-22 21:39:46 6. /build/src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbab0 2024-07-22 21:39:46 7. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 8. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 9. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 10. /build/src/Common/CurrentMemoryTracker.cpp:84: CurrentMemoryTracker::check() @ 0x0000000013248c59 2024-07-22 21:39:46 11. /build/src/Interpreters/Aggregator.cpp:1859: DB::Aggregator::checkLimits(unsigned long, bool&) const @ 0x000000001a708717 2024-07-22 21:39:46 12. /build/src/Interpreters/Aggregator.cpp:1645: DB::Aggregator::executeOnBlock(std::vector::immutable_ptr, std::allocator::immutable_ptr>>, unsigned long, unsigned long, DB::AggregatedDataVariants&, std::vector>&, std::vector>, std::allocator>>>&, bool&) const @ 0x000000001a7184fc 2024-07-22 21:39:46 13. /build/src/Processors/Transforms/AggregatingTransform.cpp:692: DB::AggregatingTransform::consume(DB::Chunk) @ 0x000000001dc83453 2024-07-22 21:39:46 14. /build/src/Processors/Transforms/AggregatingTransform.cpp:651: DB::AggregatingTransform::work() @ 0x000000001dc80559 2024-07-22 21:39:46 15. /build/src/Processors/Executors/ExecutionThreadContext.cpp:47: DB::executeJob(DB::ExecutingGraph::Node*, DB::ReadProgressCallback*) @ 0x000000001d51f843 2024-07-22 21:39:46 16. /build/src/Processors/Executors/ExecutionThreadContext.cpp:95: DB::ExecutionThreadContext::executeTask() @ 0x000000001d51f580 2024-07-22 21:39:46 17. /build/src/Processors/Executors/PipelineExecutor.cpp:273: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x000000001d501b01 2024-07-22 21:39:46 18. /build/src/Processors/Executors/PipelineExecutor.cpp:239: DB::PipelineExecutor::executeSingleThread(unsigned long) @ 0x000000001d501e97 2024-07-22 21:39:46 19. /build/src/Processors/Executors/PipelineExecutor.cpp:373: DB::PipelineExecutor::spawnThreads()::$_0::operator()() const @ 0x000000001d502e38 2024-07-22 21:39:46 20. /build/contrib/llvm-project/libcxx/include/__functional/invoke.h:394: ? @ 0x000000001d502d95 2024-07-22 21:39:46 21. /build/contrib/llvm-project/libcxx/include/__functional/invoke.h:480: ? @ 0x000000001d502d75 2024-07-22 21:39:46 22. /build/contrib/llvm-project/libcxx/include/__functional/function.h:235: ? @ 0x000000001d502d55 2024-07-22 21:39:46 23. /build/contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000001d502d20 2024-07-22 21:39:46 24. /build/contrib/llvm-project/libcxx/include/__functional/function.h:848: ? @ 0x0000000011b37036 2024-07-22 21:39:46 25. /build/contrib/llvm-project/libcxx/include/__functional/function.h:1187: ? @ 0x0000000011b36c75 2024-07-22 21:39:46 26. /build/src/Common/ThreadPool.cpp:455: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x00000000133ca61d 2024-07-22 21:39:46 27. /build/src/Common/ThreadPool.cpp:217: void ThreadPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()::operator()() const @ 0x00000000133d3bc4 2024-07-22 21:39:46 28. /build/contrib/llvm-project/libcxx/include/__functional/invoke.h:394: ? @ 0x00000000133d3b95 2024-07-22 21:39:46 29. /build/contrib/llvm-project/libcxx/include/tuple:1789: decltype(auto) std::__apply_tuple_impl[abi:v15000]>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()&, std::tuple<>&>(void&&, std::tuple<>&, std::__tuple_indices<>) @ 0x00000000133d3b79 2024-07-22 21:39:46 30. /build/contrib/llvm-project/libcxx/include/tuple:1798: decltype(auto) std::apply[abi:v15000]>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()&, std::tuple<>&>(void&&, std::tuple<>&) @ 0x00000000133d3a1d 2024-07-22 21:39:46 31. /build/src/Common/ThreadPool.h:223: ThreadFromGlobalPoolImpl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'()::operator()() @ 0x00000000133d38e5 2024-07-22 21:39:46 2024-07-22 21:39:46 Received exception from server (version 24.3.5): 2024-07-22 21:39:46 Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 27.96 GiB (attempt to allocate chunk of 0 bytes), maximum: 27.54 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: While executing AggregatingTransform. (MEMORY_LIMIT_EXCEEDED) 2024-07-22 21:39:46 (query: SELECT argMaxIf((n, n), n, n % 5 == 0) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50));) 2024-07-22 21:39:46 , result: 2024-07-22 21:39:46 2024-07-22 21:39:46 -- { echoOn } 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (9,9) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (8,8) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (9,9) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (8,8) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (5,5) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 5 == 0, NULL, number) as n from numbers(5, 10)); 2024-07-22 21:39:46 (6,6) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number::Int32) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (5,5) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number::Int32) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 5 == 0, NULL, number::Int32) as n from numbers(5, 10)); 2024-07-22 21:39:46 (6,6) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n > 100) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n < 100) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 (49,49) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n % 5 == 0) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 2024-07-22 21:39:46 stdout: 2024-07-22 21:39:46 -- { echoOn } 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (9,9) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(10)); 2024-07-22 21:39:46 (8,8) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (9,9) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMax((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number::Int32) AS n from numbers(10)); 2024-07-22 21:39:46 (8,8) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (5,5) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 5 == 0, NULL, number) as n from numbers(5, 10)); 2024-07-22 21:39:46 (6,6) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number >= 100, NULL, number::Int32) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (5,5) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number <= 100, NULL, number::Int32) AS n from numbers(5, 10)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMin((n, n), n) t, toTypeName(t) FROM (SELECT if(number % 5 == 0, NULL, number::Int32) as n from numbers(5, 10)); 2024-07-22 21:39:46 (6,6) Tuple(Nullable(Int32), Nullable(Int32)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n > 100) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 (NULL,NULL) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n < 100) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 (49,49) Tuple(Nullable(UInt64), Nullable(UInt64)) 2024-07-22 21:39:46 SELECT argMaxIf((n, n), n, n % 5 == 0) t, toTypeName(t) FROM (SELECT if(number % 3 = 0, NULL, number) AS n from numbers(50)); 2024-07-22 21:39:46 2024-07-22 21:39:46 2024-07-22 21:39:46 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 451800 --group_by_two_level_threshold_bytes 4468834 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 11870848 --max_read_buffer_size 692500 --prefer_localhost_replica 1 --max_block_size 22671 --max_threads 63 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 83 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 27809074 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method io_uring --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 6840222500 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2978032516 --min_compress_block_size 330840 --max_compress_block_size 2690148 --merge_tree_compact_parts_min_granules_to_multibuffer_read 74 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 2565522 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --prefer_warmed_unmerged_parts_seconds 1 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.53 2024-07-22 21:39:46 2024-07-22 21:39:46 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 66 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 19225485 --merge_max_block_size 17563 --index_granularity 887 --min_bytes_for_wide_part 991823410 --marks_compress_block_size 40043 --primary_key_compress_block_size 88398 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 10448244 --compact_parts_max_bytes_to_buffer 238551415 --compact_parts_max_granules_to_buffer 152 --compact_parts_merge_max_bytes_to_prefetch_part 29434921 --cache_populated_by_fetch 0 2024-07-22 21:39:46 2024-07-22 21:39:46 Database: test_8u33skjp 2024-07-22 21:39:46 02436_system_zookeeper_context: [ FAIL ] 3.62 sec. - return code: 241 2024-07-22 21:39:46 [cd337481d243] 2024.07.22 11:39:45.758719 [ 3655 ] {684d8f07-1447-4bce-b991-e2e755cca237} executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.96 GiB (attempt to allocate chunk of 1068559 bytes), maximum: 27.54 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker. (MEMORY_LIMIT_EXCEEDED) (version 24.3.5.47.altinitystable (altinity build)) (from [::1]:51328) (comment: 02436_system_zookeeper_context.sql) (in query: alter table mt update s = (select toString(groupArray((*,))) from system.zookeeper where path='/') where n=1 settings mutations_sync=2;), Stack trace (when copying this message, always include the lines below): 2024-07-22 21:39:46 2024-07-22 21:39:46 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000000a8ef122 2024-07-22 21:39:46 1. /build/contrib/llvm-project/libcxx/include/exception:116: std::exception::exception[abi:v15000]() @ 0x000000000a8ef0ed 2024-07-22 21:39:46 2. /build/base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x00000000229d6ac0 2024-07-22 21:39:46 3. /build/src/Common/Exception.cpp:94: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000132ad8ce 2024-07-22 21:39:46 4. /build/src/Common/Exception.h:90: DB::Exception::Exception(String&&, int, bool) @ 0x000000000a8e5cca 2024-07-22 21:39:46 5. /build/src/Common/Exception.h:109: DB::Exception::Exception>>(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view>&&) @ 0x00000000132dd69d 2024-07-22 21:39:46 6. /build/src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbab0 2024-07-22 21:39:46 7. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 8. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 9. /build/src/Common/MemoryTracker.cpp:398: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x00000000132dbe02 2024-07-22 21:39:46 10. /build/src/Common/CurrentMemoryTracker.cpp:58: CurrentMemoryTracker::allocImpl(long, bool) @ 0x0000000013248a91 2024-07-22 21:39:46 11. /build/src/Common/CurrentMemoryTracker.cpp:90: CurrentMemoryTracker::alloc(long) @ 0x0000000013248ca1 2024-07-22 21:39:46 12. /build/src/Common/Allocator.cpp:114: Allocator::alloc(unsigned long, unsigned long) @ 0x0000000013246cc6 2024-07-22 21:39:46 13. /build/src/IO/BufferWithOwnMemory.h:130: DB::Memory>::alloc(unsigned long) @ 0x0000000013351e8c 2024-07-22 21:39:46 14. /build/src/IO/BufferWithOwnMemory.h:50: DB::Memory>::Memory(unsigned long, unsigned long) @ 0x0000000013351cc0 2024-07-22 21:39:46 15. /build/src/IO/BufferWithOwnMemory.h:157: DB::BufferWithOwnMemory::BufferWithOwnMemory(unsigned long, char*, unsigned long) @ 0x000000001337edb5 2024-07-22 21:39:46 16. /build/src/IO/WriteBufferFromFileBase.cpp:7: DB::WriteBufferFromFileBase::WriteBufferFromFileBase(unsigned long, char*, unsigned long) @ 0x000000001337ed11 2024-07-22 21:39:46 17. /build/src/IO/WriteBufferFromFileDescriptor.cpp:98: DB::WriteBufferFromFileDescriptor::WriteBufferFromFileDescriptor(int, unsigned long, char*, std::shared_ptr, unsigned long, String) @ 0x000000001337e3c4 2024-07-22 21:39:46 18. /build/src/IO/WriteBufferFromFile.cpp:36: DB::WriteBufferFromFile::WriteBufferFromFile(String const&, unsigned long, int, std::shared_ptr, unsigned int, char*, unsigned long) @ 0x000000001351a15c 2024-07-22 21:39:46 19. /build/contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:714: std::__unique_if::__unique_single std::make_unique[abi:v15000] const&>(std::__fs::filesystem::path&&, unsigned long&, int&, std::shared_ptr const&) @ 0x000000001a2c6df5 2024-07-22 21:39:46 20. /build/src/Disks/DiskLocal.cpp:342: DB::DiskLocal::writeFile(String const&, unsigned long, DB::WriteMode, DB::WriteSettings const&) @ 0x000000001a2be45e 2024-07-22 21:39:46 21. /build/src/Storages/MergeTree/MergeTreeMutationEntry.cpp:62: DB::MergeTreeMutationEntry::MergeTreeMutationEntry(DB::MutationCommands, std::shared_ptr, String const&, unsigned long, DB::TransactionID const&, DB::WriteSettings const&) @ 0x000000001d11b82c 2024-07-22 21:39:46 22. /build/src/Storages/StorageMergeTree.cpp:518: DB::StorageMergeTree::startMutation(DB::MutationCommands const&, std::shared_ptr) @ 0x000000001d0dcdd3 2024-07-22 21:39:46 23. /build/src/Storages/StorageMergeTree.cpp:653: DB::StorageMergeTree::mutate(DB::MutationCommands const&, std::shared_ptr) @ 0x000000001d0e0a0a 2024-07-22 21:39:46 24. /build/src/Interpreters/InterpreterAlterQuery.cpp:221: DB::InterpreterAlterQuery::executeToTable(DB::ASTAlterQuery const&) @ 0x000000001afe1100 2024-07-22 21:39:46 25. /build/src/Interpreters/InterpreterAlterQuery.cpp:67: DB::InterpreterAlterQuery::execute() @ 0x000000001afde5de 2024-07-22 21:39:46 26. /build/src/Interpreters/executeQuery.cpp:1195: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000001bb92eb7 2024-07-22 21:39:46 27. /build/src/Interpreters/executeQuery.cpp:1374: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001bb8cf8a 2024-07-22 21:39:46 28. /build/src/Server/TCPHandler.cpp:517: DB::TCPHandler::runImpl() @ 0x000000001d45bd00 2024-07-22 21:39:46 29. /build/src/Server/TCPHandler.cpp:2329: DB::TCPHandler::run() @ 0x000000001d472d25 2024-07-22 21:39:46 30. /build/base/poco/Net/src/TCPServerConnection.cpp:43: Poco::Net::TCPServerConnection::start() @ 0x000000002287ed39 2024-07-22 21:39:46 31. /build/base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x000000002287f588 2024-07-22 21:39:46 2024-07-22 21:39:46 Received exception from server (version 24.3.5): 2024-07-22 21:39:46 Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 27.96 GiB (attempt to allocate chunk of 1068559 bytes), maximum: 27.54 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED) 2024-07-22 21:39:46 (query: alter table mt update s = (select toString(groupArray((*,))) from system.zookeeper where path='/') where n=1 settings mutations_sync=2;) 2024-07-22 21:39:46 , result: 2024-07-22 21:39:46 2024-07-22 21:39:46 2024-07-22 21:39:46 2024-07-22 21:39:46 stdout: 2024-07-22 21:39:46 2024-07-22 21:39:46 2024-07-22 21:39:46 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 737525 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 6113094 --max_read_buffer_size 920420 --prefer_localhost_replica 1 --max_block_size 15195 --max_threads 37 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 51 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 13343677 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 4 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 1 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 272219670 --min_compress_block_size 1916474 --max_compress_block_size 1412666 --merge_tree_compact_parts_min_granules_to_multibuffer_read 67 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4222524 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 2 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.1 2024-07-22 21:39:46 2024-07-22 21:39:46 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 777117 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 8969493564 --index_granularity_bytes 9467191 --merge_max_block_size 17360 --index_granularity 13867 --min_bytes_for_wide_part 340168219 --marks_compress_block_size 41551 --primary_key_compress_block_size 99773 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 346661052 --compact_parts_max_bytes_to_buffer 70106684 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 16642254 --cache_populated_by_fetch 1 2024-07-22 21:39:46 2024-07-22 21:39:46 Database: test_1vqo9lr1 2024-07-22 21:39:47 02428_delete_with_settings: [ OK ] 4.53 sec. 2024-07-22 21:39:48 02661_read_from_archive_7z: [ OK ] 116.08 sec. 2024-07-22 21:39:48 02661_read_from_archive_tarxz: [ OK ] 116.92 sec. 2024-07-22 21:39:50 02428_batch_nullable_assert: [ OK ] 3.41 sec. 2024-07-22 21:39:50 02428_partial_sort_optimization_bug: [ OK ] 3.74 sec. 2024-07-22 21:39:52 02426_pod_array_overflow_3: [ OK ] 3.17 sec. 2024-07-22 21:39:52 02428_decimal_in_floating_point_literal: [ OK ] 4.75 sec. 2024-07-22 21:39:53 02426_to_string_nullable_fixedstring: [ OK ] 3.38 sec. 2024-07-22 21:39:53 02426_create_suspicious_fixed_string: [ OK ] 3.24 sec. 2024-07-22 21:39:54 02481_parquet_list_monotonically_increasing_offsets: [ OK ] 39.99 sec. 2024-07-22 21:39:56 02426_orc_bug: [ OK ] 7.31 sec. 2024-07-22 21:39:57 02409_url_format_detection: [ OK ] 3.34 sec. 2024-07-22 21:39:58 02420_stracktrace_debug_symbols: [ OK ] 5.77 sec. 2024-07-22 21:39:58 02416_rocksdb_delete_update: [ OK ] 4.31 sec. 2024-07-22 21:39:58 02418_keeper_map_keys_limit: [ OK ] 4.47 sec. 2024-07-22 21:39:59 02407_array_element_from_map_wrong_type: [ OK ] 3.19 sec. 2024-07-22 21:40:02 02403_ttl_column_multiple_times: [ OK ] 3.80 sec. 2024-07-22 21:40:02 02399_merge_tree_mutate_in_partition: [ OK ] 4.01 sec. 2024-07-22 21:40:02 02403_big_http_chunk_size: [ OK ] 4.19 sec. 2024-07-22 21:40:02 02393_every_metric_must_have_documentation: [ OK ] 3.48 sec. 2024-07-22 21:40:03 02403_enable_extended_results_for_datetime_functions: [ OK ] 6.31 sec. 2024-07-22 21:40:06 02387_parse_date_as_datetime: [ OK ] 3.55 sec. 2024-07-22 21:40:06 02388_conversion_from_string_with_datetime64_to_date_and_date32: [ OK ] 3.92 sec. 2024-07-22 21:40:06 02386_set_columns_order: [ OK ] 4.04 sec. 2024-07-22 21:40:07 02383_analyzer_merge_tree_self_join: [ OK ] 4.53 sec. 2024-07-22 21:40:09 02381_parse_array_of_tuples: [ OK ] 3.58 sec. 2024-07-22 21:40:10 02382_analyzer_matcher_join_using: [ OK ] 6.47 sec. 2024-07-22 21:40:11 02377_fix_file_virtual_column: [ OK ] 3.81 sec. 2024-07-22 21:40:11 02381_arrow_dict_to_lc: [ OK ] 5.27 sec. 2024-07-22 21:40:15 02375_pretty_formats: [ OK ] 4.00 sec. 2024-07-22 21:40:16 02437_drop_mv_restart_replicas: [ OK ] 35.01 sec. 2024-07-22 21:40:16 02423_insert_summary_behaviour: [ OK ] 24.68 sec. 2024-07-22 21:40:20 02374_in_tuple_index: [ OK ] 3.74 sec. 2024-07-22 21:40:21 02377_majority_insert_quorum_zookeeper_long: [ OK ] 11.28 sec. 2024-07-22 21:40:23 02375_stack_trace_no_addresses: [ OK ] 7.65 sec. 2024-07-22 21:40:23 02380_insert_mv_race: [ OK ] 16.93 sec. 2024-07-22 21:40:24 02373_progress_contain_result: [ OK ] 4.15 sec. 2024-07-22 21:40:27 02370_analyzer_in_function: [ OK ] 4.00 sec. 2024-07-22 21:40:28 02364_dictionary_datetime_64_attribute_crash: [ OK ] 3.59 sec. 2024-07-22 21:40:32 02357_file_default_value: [ OK ] 3.57 sec. 2024-07-22 21:40:32 02374_analyzer_join_using: [ OK ] 16.00 sec. 2024-07-22 21:40:36 02366_kql_func_ip: [ OK ] 12.79 sec. 2024-07-22 21:40:36 02354_vector_search_default_granularity: [ OK ] 4.36 sec. 2024-07-22 21:40:40 02354_vector_search_queries: [ FAIL ] 7.21 sec. - result differs with reference: 2024-07-22 21:40:40 --- /usr/share/clickhouse-test/queries/0_stateless/02354_vector_search_queries.reference 2024-07-22 21:29:58.773612249 +0300 2024-07-22 21:40:40 +++ /tmp/clickhouse-test/0_stateless/02354_vector_search_queries.stdout 2024-07-22 21:40:40.161300145 +0300 2024-07-22 21:40:40 @@ -16,7 +16,7 @@ 2024-07-22 21:40:40 6 [0,2.1] 0.09999990463256836 2024-07-22 21:40:40 7 [0,2.2] 0.20000004768371582 2024-07-22 21:40:40 - Annoy: WHERE-type, EXPLAIN 2024-07-22 21:40:40 -Expression ((Projection + Before ORDER BY)) 2024-07-22 21:40:40 +Expression ((Project names + Projection)) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Expression 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_annoy) 2024-07-22 21:40:40 @@ -25,29 +25,19 @@ 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 1/1 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: annoy GRANULARITY 100000000 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/1 2024-07-22 21:40:40 - Annoy: ORDER-BY-type, EXPLAIN 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_annoy) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 1/1 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: annoy GRANULARITY 100000000 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/1 2024-07-22 21:40:40 - Usearch: WHERE-type, EXPLAIN 2024-07-22 21:40:40 -Expression ((Projection + Before ORDER BY)) 2024-07-22 21:40:40 +Expression ((Project names + Projection)) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Expression 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_usearch) 2024-07-22 21:40:40 @@ -56,27 +46,17 @@ 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 1/1 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: usearch GRANULARITY 100000000 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/1 2024-07-22 21:40:40 - Usearch: ORDER-BY-type, EXPLAIN 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_usearch) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 1/1 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: usearch GRANULARITY 100000000 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/1 2024-07-22 21:40:40 ARRAY vectors, 12 rows, index_granularity = 3, GRANULARITY = 2 --> 4 granules, 2 indexed block 2024-07-22 21:40:40 - Annoy: WHERE-type 2024-07-22 21:40:40 6 [0,2] 0 2024-07-22 21:40:40 @@ -95,7 +75,7 @@ 2024-07-22 21:40:40 7 [0,2.1] 0.09999990463256836 2024-07-22 21:40:40 8 [0,2.2] 0.20000004768371582 2024-07-22 21:40:40 - Annoy: WHERE-type, EXPLAIN 2024-07-22 21:40:40 -Expression ((Projection + Before ORDER BY)) 2024-07-22 21:40:40 +Expression ((Project names + Projection)) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Expression 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_annoy) 2024-07-22 21:40:40 @@ -104,29 +84,19 @@ 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 4/4 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: annoy GRANULARITY 2 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/4 2024-07-22 21:40:40 - Annoy: ORDER-BY-type, EXPLAIN 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_annoy) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 4/4 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: annoy GRANULARITY 2 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 2/4 2024-07-22 21:40:40 - Usearch: WHERE-type, EXPLAIN 2024-07-22 21:40:40 -Expression ((Projection + Before ORDER BY)) 2024-07-22 21:40:40 +Expression ((Project names + Projection)) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Expression 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_usearch) 2024-07-22 21:40:40 @@ -135,27 +105,17 @@ 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 4/4 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: usearch GRANULARITY 2 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 1/4 2024-07-22 21:40:40 - Usearch: ORDER-BY-type, EXPLAIN 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_usearch) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 Condition: true 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 4/4 2024-07-22 21:40:40 - Skip 2024-07-22 21:40:40 - Name: idx 2024-07-22 21:40:40 - Description: usearch GRANULARITY 2 2024-07-22 21:40:40 - Parts: 1/1 2024-07-22 21:40:40 - Granules: 2/4 2024-07-22 21:40:40 TUPLE vectors and special cases 2024-07-22 21:40:40 - Annoy: WHERE-type 2024-07-22 21:40:40 0 (4.6,2.3) 0.5527864045000421 2024-07-22 21:40:40 @@ -163,24 +123,27 @@ 2024-07-22 21:40:40 2 (4.2,3.4) 0.37080174340866845 2024-07-22 21:40:40 - Annoy: ORDER-BY-type 2024-07-22 21:40:40 6 (1,9.3) 0.005731362878640178 2024-07-22 21:40:40 +4 (2.4,5.2) 0.09204062768384846 2024-07-22 21:40:40 1 (2,3.2) 0.15200169244542905 2024-07-22 21:40:40 -7 (5.5,4.7) 0.3503476876550442 2024-07-22 21:40:40 - Usearch: WHERE-type 2024-07-22 21:40:40 0 (4.6,2.3) 0.5527864045000421 2024-07-22 21:40:40 1 (2,3.2) 0.15200169244542905 2024-07-22 21:40:40 2 (4.2,3.4) 0.37080174340866845 2024-07-22 21:40:40 - Usearch: ORDER-BY-type 2024-07-22 21:40:40 6 (1,9.3) 0.005731362878640178 2024-07-22 21:40:40 +4 (2.4,5.2) 0.09204062768384846 2024-07-22 21:40:40 1 (2,3.2) 0.15200169244542905 2024-07-22 21:40:40 -7 (5.5,4.7) 0.3503476876550442 2024-07-22 21:40:40 - Special case: MaximumDistance is negative 2024-07-22 21:40:40 - Special case: MaximumDistance is negative 2024-07-22 21:40:40 - Special case: setting "annoy_index_search_k_nodes" 2024-07-22 21:40:40 +6 (1,9.3) 0.005731362878640178 2024-07-22 21:40:40 +4 (2.4,5.2) 0.09204062768384846 2024-07-22 21:40:40 +1 (2,3.2) 0.15200169244542905 2024-07-22 21:40:40 - Special case: setting "max_limit_for_ann_queries" 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_annoy) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 @@ -188,10 +151,10 @@ 2024-07-22 21:40:40 Parts: 1/1 2024-07-22 21:40:40 Granules: 4/4 2024-07-22 21:40:40 - Special case: setting "max_limit_for_ann_queries" 2024-07-22 21:40:40 -Expression (Projection) 2024-07-22 21:40:40 +Expression (Project names) 2024-07-22 21:40:40 Limit (preliminary LIMIT (without OFFSET)) 2024-07-22 21:40:40 Sorting (Sorting for ORDER BY) 2024-07-22 21:40:40 - Expression (Before ORDER BY) 2024-07-22 21:40:40 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2024-07-22 21:40:40 ReadFromMergeTree (default.tab_usearch) 2024-07-22 21:40:40 Indexes: 2024-07-22 21:40:40 PrimaryKey 2024-07-22 21:40:40 2024-07-22 21:40:40 2024-07-22 21:40:40 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 29644 --group_by_two_level_threshold_bytes 44822898 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 10064715 --max_read_buffer_size 953559 --prefer_localhost_replica 1 --max_block_size 73597 --max_threads 60 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 92 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 5246229 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 5311774490 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2414970935 --min_compress_block_size 708384 --max_compress_block_size 1886209 --merge_tree_compact_parts_min_granules_to_multibuffer_read 110 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 8554224 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 0 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.06 2024-07-22 21:40:40 2024-07-22 21:40:40 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.46090361849728145 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 39 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 2736727846 --index_granularity_bytes 14094835 --merge_max_block_size 6870 --index_granularity 8077 --min_bytes_for_wide_part 257091881 --marks_compress_block_size 71816 --primary_key_compress_block_size 9742 --replace_long_file_name_to_hash 1 --max_file_name_length 95 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 83082976 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 4649821 --cache_populated_by_fetch 0 2024-07-22 21:40:40 2024-07-22 21:40:40 Database: test_zjko9jzf 2024-07-22 21:40:41 02360_send_logs_level_colors: [ OK ] 14.08 sec. 2024-07-22 21:40:44 02352_lightweight_delete_on_replicated_merge_tree: [ OK ] 7.87 sec. 2024-07-22 21:40:45 02346_inverted_index_bug47393: [ OK ] 3.87 sec. 2024-07-22 21:40:46 02347_rank_corr_size_overflow: [ OK ] 6.43 sec. 2024-07-22 21:40:48 02346_position_countsubstrings_zero_byte: [ OK ] 4.20 sec. 2024-07-22 21:40:49 02352_lightweight_delete: [ OK ] 13.18 sec. 2024-07-22 21:40:52 02346_inverted_index_bug52019: [ OK ] 3.79 sec. 2024-07-22 21:40:53 02345_partial_sort_transform_optimization: [ OK ] 3.86 sec. 2024-07-22 21:40:55 02375_rocksdb_with_filters: [ OK ] 43.64 sec. 2024-07-22 21:40:56 02343_create_empty_as_select: [ OK ] 2.95 sec. 2024-07-22 21:40:57 02343_group_by_use_nulls_distributed: [ OK ] 4.77 sec. 2024-07-22 21:40:58 02337_multiple_joins_original_names: [ OK ] 3.74 sec. 2024-07-22 21:41:00 02337_check_translate_qualified_names_matcher: [ OK ] 3.45 sec. 2024-07-22 21:41:02 02320_mapped_array_witn_const_nullable: [ OK ] 3.53 sec. 2024-07-22 21:41:05 02319_dict_get_check_arguments_size: [ OK ] 4.81 sec. 2024-07-22 21:41:08 02319_no_columns_in_row_level_filter: [ OK ] 5.69 sec. 2024-07-22 21:41:11 02317_functions_with_nothing: [ OK ] 3.55 sec. 2024-07-22 21:41:13 02496_remove_redundant_sorting: [ OK ] 126.45 sec. 2024-07-22 21:41:15 02317_like_with_trailing_escape: [ OK ] 3.84 sec. 2024-07-22 21:41:15 02317_distinct_in_order_optimization: [ OK ] 10.66 sec. 2024-07-22 21:41:16 02346_into_outfile_and_stdout: [ OK ] 29.82 sec. 2024-07-22 21:41:17 02316_cast_to_ip_address_default_column: [ OK ] 4.03 sec. 2024-07-22 21:41:19 02316_expressions_with_window_functions: [ OK ] 3.83 sec. 2024-07-22 21:41:20 02311_range_hashed_dictionary_range_cast: [ OK ] 3.83 sec. 2024-07-22 21:41:21 02316_hierarchical_dictionaries_nullable_parent_key: [ OK ] 6.20 sec. 2024-07-22 21:41:23 02307_join_get_array_null: [ OK ] 3.66 sec. 2024-07-22 21:41:26 02310_profile_events_insert: [ OK ] 8.87 sec. 2024-07-22 21:41:26 02296_nullable_arguments_in_array_filter: [ OK ] 3.54 sec. 2024-07-22 21:41:27 02302_clash_const_aggegate_join: [ OK ] 5.42 sec. 2024-07-22 21:41:27 02324_compatibility_setting: [ OK ] 30.53 sec. 2024-07-22 21:41:32 02291_join_const_literal_36279: [ OK ] 4.58 sec. 2024-07-22 21:41:34 02346_inverted_index_search: [ OK ] 48.76 sec. 2024-07-22 21:41:35 02286_convert_decimal_type: [ OK ] 3.38 sec. 2024-07-22 21:41:36 02294_nothing_arguments_in_functions_errors: [ OK ] 9.38 sec. 2024-07-22 21:41:39 02286_vertical_merges_missed_column: [ OK ] 4.10 sec. 2024-07-22 21:41:40 02285_hex_bin_support_more_types: [ OK ] 4.22 sec. 2024-07-22 21:41:40 02294_floating_point_second_in_settings: [ OK ] 14.37 sec. 2024-07-22 21:41:46 02267_join_dup_columns_issue36199: [ OK ] 5.46 sec. 2024-07-22 21:41:47 02270_client_name: [ OK ] 7.60 sec. 2024-07-22 21:41:50 02370_lost_part_intersecting_merges: [ OK ] 89.21 sec. 2024-07-22 21:41:50 02250_insert_select_from_file_schema_inference: [ OK ] 3.58 sec. 2024-07-22 21:41:54 02249_insert_select_from_input_schema_inference: [ OK ] 3.47 sec. 2024-07-22 21:41:55 02305_schema_inference_with_globs: [ OK ] 34.84 sec. 2024-07-22 21:41:58 02245_weird_partitions_pruning: [ OK ] 3.75 sec. 2024-07-22 21:42:00 02244_ip_address_invalid_insert: [ OK ] 4.84 sec. 2024-07-22 21:42:01 02243_ipv6_long_parsing: [ OK ] 3.76 sec. 2024-07-22 21:42:04 02286_parallel_final: [ OK ] 36.09 sec. 2024-07-22 21:42:07 02240_get_type_serialization_streams: [ OK ] 3.44 sec. 2024-07-22 21:42:10 02236_explain_pipeline_join: [ OK ] 3.20 sec. 2024-07-22 21:42:14 02250_hints_for_columns: [ OK ] 23.23 sec. 2024-07-22 21:42:16 02286_quantile_tdigest_infinity: [ OK ] 42.19 sec. 2024-07-22 21:42:17 02233_with_total_empty_chunk: [ OK ] 3.25 sec. 2024-07-22 21:42:17 02270_errors_in_files: [ OK ] 37.04 sec. 2024-07-22 21:42:20 02243_arrow_read_null_type_to_nullable_column: [ OK ] 20.25 sec. 2024-07-22 21:42:21 02232_partition_pruner_single_point: [ OK ] 3.81 sec. 2024-07-22 21:42:21 02232_partition_pruner_mixed_constant_type: [ OK ] 3.71 sec. 2024-07-22 21:42:21 02233_HTTP_ranged: [ OK ] 5.18 sec. 2024-07-22 21:42:25 02226_in_untuple_issue_34810: [ OK ] 3.78 sec. 2024-07-22 21:42:25 02231_hierarchical_dictionaries_constant: [ OK ] 4.52 sec. 2024-07-22 21:42:28 02377_optimize_sorting_by_input_stream_properties_explain: [ OK ] 139.08 sec. 2024-07-22 21:42:29 02224_s2_test_const_columns: [ OK ] 3.45 sec. 2024-07-22 21:42:30 02226_low_cardinality_text_bloom_filter_index: [ OK ] 5.28 sec. 2024-07-22 21:42:32 02210_append_to_dev_dull: [ OK ] 3.59 sec. 2024-07-22 21:42:33 02223_h3_test_const_columns: [ OK ] 4.78 sec. 2024-07-22 21:42:34 02235_brotli_bug: [ OK ] 24.07 sec. 2024-07-22 21:42:35 02227_test_create_empty_sqlite_db: [ OK ] 14.46 sec. 2024-07-22 21:42:36 02209_short_circuit_node_without_parents: [ OK ] 3.39 sec. 2024-07-22 21:42:37 02253_empty_part_checksums: [ OK ] 50.87 sec. 2024-07-22 21:42:38 02207_key_condition_floats: [ OK ] 4.47 sec. 2024-07-22 21:42:40 02206_clickhouse_local_use_database: [ OK ] 5.35 sec. 2024-07-22 21:42:41 02205_HTTP_user_agent: [ OK ] 4.03 sec. 2024-07-22 21:42:41 02190_current_metrics_query: [ OK ] 3.29 sec. 2024-07-22 21:42:41 02231_buffer_aggregate_states_leak: [ OK ] 21.11 sec. 2024-07-22 21:42:42 02205_postgresql_functions: [ OK ] 6.11 sec. 2024-07-22 21:42:43 02187_test_final_and_limit_modifier: [ OK ] 3.49 sec. 2024-07-22 21:42:44 02184_ipv6_cast_test: [ OK ] 3.54 sec. 2024-07-22 21:42:45 02184_ipv6_select_parsing: [ OK ] 3.49 sec. 2024-07-22 21:42:45 02186_range_hashed_dictionary_intersecting_intervals: [ OK ] 4.33 sec. 2024-07-22 21:42:46 02206_format_override: [ OK ] 10.42 sec. 2024-07-22 21:42:47 02183_array_tuple_literals_remote: [ OK ] 4.87 sec. 2024-07-22 21:42:48 02179_bool_type: [ OK ] 4.55 sec. 2024-07-22 21:42:49 02167_columns_with_dots_default_values: [ OK ] 3.61 sec. 2024-07-22 21:42:49 02179_sparse_columns_detach: [ OK ] 4.45 sec. 2024-07-22 21:42:50 02176_dict_get_has_implicit_key_cast: [ OK ] 5.15 sec. 2024-07-22 21:42:50 02165_h3_exact_edge_length_m: [ OK ] 3.90 sec. 2024-07-22 21:42:51 02165_h3_exact_edge_length_Km: [ OK ] 3.86 sec. 2024-07-22 21:42:52 02165_replicated_grouping_sets: [ OK ] 4.36 sec. 2024-07-22 21:42:53 02162_range_hashed_dictionary_ddl_expression: [ OK ] 3.79 sec. 2024-07-22 21:42:53 02160_h3_hex_area_Km2: [ OK ] 3.63 sec. 2024-07-22 21:42:54 02163_shard_num: [ OK ] 4.85 sec. 2024-07-22 21:42:54 02160_h3_cell_area_m2: [ OK ] 3.86 sec. 2024-07-22 21:42:54 02210_processors_profile_log_2: [ OK ] 24.05 sec. 2024-07-22 21:42:56 02160_h3_cell_area_rads2: [ OK ] 3.75 sec. 2024-07-22 21:42:57 02158_contingency: [ OK ] 3.76 sec. 2024-07-22 21:42:58 02160_special_functions: [ OK ] 4.17 sec. 2024-07-22 21:42:59 02160_untuple_exponential_growth: [ OK ] 7.65 sec. 2024-07-22 21:43:00 02155_h3_to_center_child: [ OK ] 6.30 sec. 2024-07-22 21:43:01 02152_csv_tuple: [ OK ] 3.86 sec. 2024-07-22 21:43:01 02153_clickhouse_local_profile_info: [ OK ] 5.22 sec. 2024-07-22 21:43:03 02160_client_autocomplete_parse_query: [ OK ] 9.67 sec. 2024-07-22 21:43:04 02151_clickhouse_client_hints: [ OK ] 5.85 sec. 2024-07-22 21:43:06 02131_remove_columns_in_subquery: [ OK ] 3.45 sec. 2024-07-22 21:43:08 02135_local_create_db: [ OK ] 6.53 sec. 2024-07-22 21:43:08 02126_url_auth: [ OK ] 4.64 sec. 2024-07-22 21:43:10 02240_protobuflist_format_persons: [ OK ] 68.13 sec. 2024-07-22 21:43:10 02151_http_s_structure_set_eof: [ OK ] 11.70 sec. 2024-07-22 21:43:12 02125_constant_if_condition_and_not_existing_column: [ OK ] 3.61 sec. 2024-07-22 21:43:12 02136_kill_scalar_queries: [ OK ] 10.62 sec. 2024-07-22 21:43:13 02125_query_views_log: [ OK ] 6.74 sec. 2024-07-22 21:43:14 02124_encrypt_decrypt_nullable: [ OK ] 3.84 sec. 2024-07-22 21:43:15 02123_MySQLWire_regression: [ OK ] 3.60 sec. 2024-07-22 21:43:17 02154_parser_backtracking: [ OK ] 23.07 sec. 2024-07-22 21:43:23 02149_schema_inference_formats_with_schema_3: [ OK ] 23.00 sec. 2024-07-22 21:43:32 02122_parallel_formatting_CSVWithNamesAndTypes: [ OK ] 18.94 sec. 2024-07-22 21:43:34 02122_parallel_formatting_Template: [ OK ] 20.63 sec. 2024-07-22 21:43:34 02118_show_create_table_rocksdb: [ OK ] 2.42 sec. 2024-07-22 21:43:35 02122_parallel_formatting_JSONCompactEachRow: [ OK ] 19.21 sec. 2024-07-22 21:43:38 02113_format_row: [ OK ] 3.54 sec. 2024-07-22 21:43:38 02113_format_row_bug: [ OK ] 3.31 sec. 2024-07-22 21:43:42 02116_interactive_hello: [ OK ] 7.39 sec. 2024-07-22 21:43:43 02112_delayed_clickhouse_local_with_queries_file: [ OK ] 5.27 sec. 2024-07-22 21:43:46 02111_with_fill_no_rows: [ OK ] 3.85 sec. 2024-07-22 21:43:46 02112_with_fill_interval: [ OK ] 7.70 sec. 2024-07-22 21:43:47 02111_global_context_temporary_tables: [ OK ] 3.52 sec. 2024-07-22 21:43:50 02122_parallel_formatting_JSONStrings: [ OK ] 32.87 sec. 2024-07-22 21:43:51 02104_clickhouse_local_columns_description: [ OK ] 5.52 sec. 2024-07-22 21:43:51 02100_alter_scalar_circular_deadlock: [ OK ] 4.37 sec. 2024-07-22 21:43:53 02122_parallel_formatting_JSONStringsEachRow: [ OK ] 29.32 sec. 2024-07-22 21:43:55 02096_totals_global_in_bug: [ OK ] 3.51 sec. 2024-07-22 21:43:55 02071_lower_upper_utf8_row_overlaps: [ OK ] 3.62 sec. 2024-07-22 21:43:59 02052_last_granula_adjust_logical_error: [ OK ] 6.12 sec. 2024-07-22 21:43:59 02047_alias_for_table_and_database_name: [ OK ] 4.20 sec. 2024-07-22 21:44:02 02124_insert_deduplication_token_multiple_blocks: [ OK ] 51.84 sec. 2024-07-22 21:44:03 02041_test_fuzzy_alter: [ OK ] 3.71 sec. 2024-07-22 21:44:05 02122_4letter_words_stress_zookeeper: [ OK ] 53.13 sec. 2024-07-22 21:44:06 02041_openssl_hash_functions_test: [ OK ] 3.84 sec. 2024-07-22 21:44:07 02036_jit_short_circuit: [ OK ] 3.87 sec. 2024-07-22 21:44:09 02125_lz4_compression_bug_JSONStringsEachRow: [ OK ] 60.90 sec. 2024-07-22 21:44:10 02029_output_csv_null_representation: [ OK ] 3.60 sec. 2024-07-22 21:44:11 02026_describe_include_subcolumns: [ OK ] 3.60 sec. 2024-07-22 21:44:15 02021_h3_is_res_classIII: [ OK ] 3.92 sec. 2024-07-22 21:44:19 02022_bzip2_truncated: [ OK ] 8.79 sec. 2024-07-22 21:44:19 02097_json_strings_deserialization: [ OK ] 28.84 sec. 2024-07-22 21:44:21 02033_join_engine_deadlock_long: [ OK ] 16.27 sec. 2024-07-22 21:44:22 02020_cast_integer_overflow: [ OK ] 3.21 sec. 2024-07-22 21:44:23 02020_exponential_smoothing_cross_block: [ OK ] 3.42 sec. 2024-07-22 21:44:25 02017_order_by_with_fill_redundant_functions: [ OK ] 3.22 sec. 2024-07-22 21:44:26 02020_exponential_smoothing: [ OK ] 10.95 sec. 2024-07-22 21:44:29 02016_agg_empty_result_bug_28880: [ OK ] 3.74 sec. 2024-07-22 21:44:29 02017_bit_shift_left_for_string_integer: [ OK ] 7.38 sec. 2024-07-22 21:44:29 02016_aggregation_spark_bar: [ OK ] 6.74 sec. 2024-07-22 21:44:32 02012_settings_clause_for_s3: [ OK ] 3.48 sec. 2024-07-22 21:44:33 02006_h3_to_geo_boundary: [ OK ] 3.95 sec. 2024-07-22 21:44:35 02007_test_any_all_operators: [ OK ] 5.82 sec. 2024-07-22 21:44:38 02006_test_positional_arguments: [ OK ] 6.18 sec. 2024-07-22 21:44:39 02002_parse_map_int_key: [ OK ] 3.53 sec. 2024-07-22 21:44:42 02001_select_with_filter: [ OK ] 3.50 sec. 2024-07-22 21:44:42 02015_async_inserts_1: [ OK ] 16.53 sec. 2024-07-22 21:44:43 02001_dist_on_dist_WithMergeableStateAfterAggregation: [ OK ] 3.72 sec. 2024-07-22 21:44:45 02003_compress_bz2: [ OK ] 11.11 sec. 2024-07-22 21:44:45 02000_table_function_cluster_macros: [ OK ] 3.53 sec. 2024-07-22 21:44:47 01949_heredoc_unfinished: [ OK ] 4.23 sec. 2024-07-22 21:44:47 02025_storage_filelog_virtual_col: [ OK ] 37.87 sec. 2024-07-22 21:44:48 01948_heredoc: [ OK ] 3.61 sec. 2024-07-22 21:44:50 01944_insert_partition_by: [ OK ] 4.55 sec. 2024-07-22 21:44:51 01937_nested_chinese: [ OK ] 3.60 sec. 2024-07-22 21:44:52 01925_date_date_time_comparison: [ OK ] 3.28 sec. 2024-07-22 21:44:53 01925_join_materialized_columns: [ OK ] 5.44 sec. 2024-07-22 21:44:54 01922_array_join_with_index: [ OK ] 3.47 sec. 2024-07-22 21:44:55 01917_system_data_skipping_indices: [ OK ] 3.67 sec. 2024-07-22 21:44:56 01916_multiple_join_view_optimize_predicate_chertus: [ OK ] 3.81 sec. 2024-07-22 21:44:57 01915_for_each_crakjie: [ OK ] 3.64 sec. 2024-07-22 21:44:58 01921_datatype_date32: [ OK ] 7.72 sec. 2024-07-22 21:44:59 01949_clickhouse_local_with_remote_localhost: [ OK ] 16.37 sec. 2024-07-22 21:44:59 01915_merge_prewhere_virtual_column_rand_chao_wang: [ OK ] 3.84 sec. 2024-07-22 21:45:00 01913_if_int_decimal: [ OK ] 3.39 sec. 2024-07-22 21:45:01 01913_join_push_down_bug: [ OK ] 3.70 sec. 2024-07-22 21:45:02 01910_memory_tracking_topk: [ OK ] 3.44 sec. 2024-07-22 21:45:02 01909_mbtolou: [ OK ] 3.84 sec. 2024-07-22 21:45:03 01905_to_json_string: [ OK ] 3.43 sec. 2024-07-22 21:45:05 01891_partition_by_uuid: [ OK ] 3.48 sec. 2024-07-22 21:45:06 01891_partition_hash_no_long_int: [ OK ] 3.87 sec. 2024-07-22 21:45:06 01890_stem: [ OK ] 3.80 sec. 2024-07-22 21:45:09 02047_log_family_data_file_dumps: [ OK ] 74.58 sec. 2024-07-22 21:45:11 01888_bloom_filter_hasAny: [ OK ] 4.46 sec. 2024-07-22 21:45:11 01888_read_int_safe: [ OK ] 4.44 sec. 2024-07-22 21:45:12 02047_log_family_data_file_sizes: [ OK ] 73.56 sec. 2024-07-22 21:45:13 01893_jit_aggregation_function_min_long: [ OK ] 12.73 sec. 2024-07-22 21:45:13 01892_jit_aggregation_function_any_last_long: [ OK ] 12.39 sec. 2024-07-22 21:45:14 01883_subcolumns_distributed: [ OK ] 4.18 sec. 2024-07-22 21:45:14 01881_aggregate_functions_versioning: [ OK ] 2.69 sec. 2024-07-22 21:45:15 01882_scalar_subquery_exception: [ OK ] 4.32 sec. 2024-07-22 21:45:16 01881_total_bytes_storage_buffer: [ OK ] 3.88 sec. 2024-07-22 21:45:17 01869_function_modulo_legacy: [ OK ] 3.35 sec. 2024-07-22 21:45:18 01854_s2_cap_contains: [ OK ] 3.94 sec. 2024-07-22 21:45:18 01871_merge_tree_compile_expressions: [ OK ] 5.22 sec. 2024-07-22 21:45:20 01852_multiple_joins_with_union_join: [ OK ] 3.66 sec. 2024-07-22 21:45:20 01851_s2_to_geo: [ OK ] 3.41 sec. 2024-07-22 21:45:21 01851_hedged_connections_external_tables: [ OK ] 3.53 sec. 2024-07-22 21:45:22 01860_Distributed__shard_num_GROUP_BY: [ OK ] 7.96 sec. 2024-07-22 21:45:23 01849_geoToS2: [ OK ] 4.90 sec. 2024-07-22 21:45:23 01854_HTTP_dict_decompression: [ OK ] 8.16 sec. 2024-07-22 21:45:24 01845_add_testcase_for_arrayElement: [ OK ] 3.68 sec. 2024-07-22 21:45:24 01835_alias_to_primary_key_cyfdecyf: [ OK ] 3.72 sec. 2024-07-22 21:45:25 01831_max_streams: [ OK ] 3.40 sec. 2024-07-22 21:45:28 01825_type_json_9: [ OK ] 3.51 sec. 2024-07-22 21:45:28 01825_type_json_nullable: [ OK ] 3.91 sec. 2024-07-22 21:45:28 01825_type_json_2: [ OK ] 4.53 sec. 2024-07-22 21:45:33 01825_type_json_sparse: [ OK ] 5.06 sec. 2024-07-22 21:45:46 01825_type_json_7: [ OK ] 23.14 sec. 2024-07-22 21:45:48 01825_type_json_16: [ OK ] 26.67 sec. 2024-07-22 21:45:52 01821_to_date_time_ubsan: [ OK ] 3.53 sec. 2024-07-22 21:45:54 01825_type_json_12: [ OK ] 26.73 sec. 2024-07-22 21:45:57 01818_move_partition_simple: [ OK ] 4.66 sec. 2024-07-22 21:45:58 01818_case_float_value_fangyc: [ OK ] 3.24 sec. 2024-07-22 21:45:58 01825_type_json_btc: [ OK ] 33.75 sec. 2024-07-22 21:46:01 02102_row_binary_with_names_and_types: [ OK ] 135.38 sec. 2024-07-22 21:46:01 01811_filter_by_null: [ OK ] 3.52 sec. 2024-07-22 21:46:03 01809_inactive_parts_to_delay_throw_insert: [ OK ] 4.63 sec. 2024-07-22 21:46:03 01812_basic_auth_http_server: [ OK ] 6.47 sec. 2024-07-22 21:46:04 01804_uniq_up_to_ubsan: [ OK ] 3.19 sec. 2024-07-22 21:46:05 01825_type_json_schema_inference: [ OK ] 36.93 sec. 2024-07-22 21:46:05 01802_rank_corr_mann_whitney_over_window: [ OK ] 3.80 sec. 2024-07-22 21:46:07 01801_distinct_group_by_shard: [ OK ] 3.43 sec. 2024-07-22 21:46:09 01795_TinyLog_rwlock_ub: [ OK ] 3.54 sec. 2024-07-22 21:46:11 01780_column_sparse: [ OK ] 4.48 sec. 2024-07-22 21:46:12 01801_s3_cluster: [ OK ] 8.91 sec. 2024-07-22 21:46:13 01798_uniq_theta_sketch: [ OK ] 8.39 sec. 2024-07-22 21:46:13 01780_column_sparse_pk: [ OK ] 4.45 sec. 2024-07-22 21:46:15 01779_quantile_deterministic_msan: [ OK ] 3.40 sec. 2024-07-22 21:46:16 01778_where_with_column_name: [ OK ] 3.57 sec. 2024-07-22 21:46:16 01776_decrypt_aead_size_check: [ OK ] 3.15 sec. 2024-07-22 21:46:16 01774_case_sensitive_connection_id: [ OK ] 3.33 sec. 2024-07-22 21:46:17 01786_nullable_string_tsv_at_eof: [ OK ] 11.87 sec. 2024-07-22 21:46:18 01773_datetime64_add_ubsan: [ OK ] 3.16 sec. 2024-07-22 21:46:19 01771_datetime64_no_time_part: [ OK ] 3.45 sec. 2024-07-22 21:46:20 01761_round_year_bounds: [ OK ] 3.35 sec. 2024-07-22 21:46:21 01764_collapsing_merge_adaptive_granularity: [ OK ] 4.48 sec. 2024-07-22 21:46:23 01753_fix_clickhouse_format: [ OK ] 4.82 sec. 2024-07-22 21:46:23 01752_distributed_query_sigsegv: [ OK ] 3.80 sec. 2024-07-22 21:46:24 01746_test_for_tupleElement_must_be_constant_issue: [ OK ] 4.63 sec. 2024-07-22 21:46:25 01753_optimize_aggregation_in_order: [ OK ] 7.71 sec. 2024-07-22 21:46:25 01739_index_hint: [ OK ] 4.67 sec. 2024-07-22 21:46:27 01732_bigint_ubsan: [ OK ] 4.19 sec. 2024-07-22 21:46:27 01720_constraints_complex_types: [ OK ] 4.12 sec. 2024-07-22 21:46:28 01717_global_with_subquery_fix: [ OK ] 3.13 sec. 2024-07-22 21:46:28 01715_table_function_view_fix: [ OK ] 3.21 sec. 2024-07-22 21:46:30 01710_projection_group_by_order_by: [ OK ] 2.36 sec. 2024-07-22 21:46:30 01711_decimal_multiplication: [ OK ] 3.38 sec. 2024-07-22 21:46:32 01710_projections_and_duplicate_columms: [ OK ] 4.03 sec. 2024-07-22 21:46:33 01710_projection_with_mixed_pipeline: [ OK ] 3.97 sec. 2024-07-22 21:46:34 01710_projections_order_by_complete: [ OK ] 3.63 sec. 2024-07-22 21:46:35 01710_projection_external_aggregate: [ OK ] 4.82 sec. 2024-07-22 21:46:36 01710_projection_in_index: [ OK ] 3.99 sec. 2024-07-22 21:46:38 01889_sqlite_read_write: [ OK ] 92.16 sec. 2024-07-22 21:46:38 01710_projection_in_set: [ OK ] 3.95 sec. 2024-07-22 21:46:39 01710_projection_aggregation_in_order: [ OK ] 4.49 sec. 2024-07-22 21:46:41 01710_minmax_count_projection_count_nullable: [ OK ] 3.78 sec. 2024-07-22 21:46:42 01710_projections: [ OK ] 5.81 sec. 2024-07-22 21:46:42 01710_projection_query_plan_optimization_misc: [ OK ] 3.64 sec. 2024-07-22 21:46:42 01707_join_use_nulls: [ OK ] 3.75 sec. 2024-07-22 21:46:45 01704_transform_with_float_key: [ OK ] 3.43 sec. 2024-07-22 21:46:46 01702_rewrite_avg_for_algebraic_optimization: [ OK ] 4.12 sec. 2024-07-22 21:46:46 01701_clear_projection_and_part_remove: [ OK ] 4.15 sec. 2024-07-22 21:46:47 01701_if_tuple_segfault: [ OK ] 4.67 sec. 2024-07-22 21:46:47 01681_hyperscan_debug_assertion: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:46:49 01683_intdiv_ubsan: [ OK ] 3.25 sec. 2024-07-22 21:46:50 01683_dist_INSERT_block_structure_mismatch: [ OK ] 3.64 sec. 2024-07-22 21:46:52 01681_bloom_filter_nullable_column: [ OK ] 4.57 sec. 2024-07-22 21:46:53 01677_bit_float: [ OK ] 4.01 sec. 2024-07-22 21:46:53 01677_array_enumerate_bug: [ OK ] 3.39 sec. 2024-07-22 21:46:56 01825_type_json_ghdata: [ OK ] 69.50 sec. 2024-07-22 21:46:56 01710_projection_analysis_reuse_partition: [ OK ] 23.45 sec. 2024-07-22 21:46:56 01676_reinterpret_as: [ OK ] 4.64 sec. 2024-07-22 21:46:57 01674_where_prewhere_array_crash: [ OK ] 3.44 sec. 2024-07-22 21:46:57 01671_test_toQuarter_mysql_dialect: [ OK ] 3.38 sec. 2024-07-22 21:46:59 01670_test_repeat_mysql_dialect: [ OK ] 3.34 sec. 2024-07-22 21:47:00 01666_date_lut_buffer_overflow: [ OK ] 3.24 sec. 2024-07-22 21:47:00 01665_running_difference_ubsan: [ OK ] 3.41 sec. 2024-07-22 21:47:00 01669_join_or_duplicates: [ OK ] 4.21 sec. 2024-07-22 21:47:00 01662_join_mixed: [ OK ] 3.48 sec. 2024-07-22 21:47:01 01720_country_intersection: [ OK ] 36.91 sec. 2024-07-22 21:47:03 01660_second_extremes_bug: [ OK ] 3.74 sec. 2024-07-22 21:47:04 01660_sum_ubsan: [ OK ] 3.69 sec. 2024-07-22 21:47:04 01661_week_functions_string_args: [ OK ] 5.30 sec. 2024-07-22 21:47:05 01659_h3_buffer_overflow: [ OK ] 4.27 sec. 2024-07-22 21:47:05 01656_ipv4_bad_formatting: [ OK ] 3.46 sec. 2024-07-22 21:47:07 01655_sleep_infinite_float: [ OK ] 3.30 sec. 2024-07-22 21:47:08 01656_join_defaul_enum: [ OK ] 4.21 sec. 2024-07-22 21:47:08 01655_test_isnull_mysql_dialect: [ OK ] 3.42 sec. 2024-07-22 21:47:11 01825_type_json_ghdata_insert_select: [ OK ] 98.46 sec. 2024-07-22 21:47:12 01646_rewrite_sum_if_bug: [ OK ] 4.03 sec. 2024-07-22 21:47:16 01644_distributed_async_insert_fsync_smoke: [ OK ] 4.78 sec. 2024-07-22 21:47:16 01642_if_nullable_regression: [ OK ] 4.34 sec. 2024-07-22 21:47:19 01648_mutations_and_escaping: [ OK ] 11.06 sec. 2024-07-22 21:47:20 01691_parser_data_type_exponential: [ OK ] 34.75 sec. 2024-07-22 21:47:20 01640_distributed_async_insert_compression: [ OK ] 3.82 sec. 2024-07-22 21:47:20 01638_div_mod_ambiguities: [ OK ] 3.59 sec. 2024-07-22 21:47:22 01651_bugs_from_15889: [ OK ] 14.30 sec. 2024-07-22 21:47:22 01654_test_writer_block_sequence: [ OK ] 17.21 sec. 2024-07-22 21:47:23 01635_sum_map_fuzz: [ OK ] 3.80 sec. 2024-07-22 21:47:23 01633_limit_fuzz: [ OK ] 3.60 sec. 2024-07-22 21:47:24 01632_select_all_syntax: [ OK ] 4.21 sec. 2024-07-22 21:47:25 01656_sequence_next_node_long: [ OK ] 24.17 sec. 2024-07-22 21:47:26 01630_simple_aggregate_function_in_summing_merge_tree: [ OK ] 4.46 sec. 2024-07-22 21:47:26 01605_adaptive_granularity_block_borders: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:47:28 01621_decode_XML: [ OK ] 3.84 sec. 2024-07-22 21:47:29 01622_codec_zstd_long: [ OK ] 5.75 sec. 2024-07-22 21:47:30 01623_constraints_column_swap: [ OK ] 7.37 sec. 2024-07-22 21:47:33 01602_insert_into_table_function_cluster: [ OK ] 4.18 sec. 2024-07-22 21:47:34 01603_insert_select_too_many_parts: [ OK ] 7.57 sec. 2024-07-22 21:47:36 01599_multiline_input_and_singleline_comments: [ OK ] 1.80 sec. 2024-07-22 21:47:39 01594_storage_join_uuid: [ OK ] 3.79 sec. 2024-07-22 21:47:41 01600_quota_by_forwarded_ip: [ OK ] 11.22 sec. 2024-07-22 21:47:43 01592_toUnixTimestamp_Date: [ OK ] 3.51 sec. 2024-07-22 21:47:45 01607_arrays_as_nested_csv: [ OK ] 20.32 sec. 2024-07-22 21:47:47 01585_use_index_for_global_in: [ OK ] 4.03 sec. 2024-07-22 21:47:49 01603_read_with_backoff_bug: [ OK ] 21.28 sec. 2024-07-22 21:47:50 01582_move_to_prewhere_compact_parts: [ OK ] 2.96 sec. 2024-07-22 21:47:54 01591_window_functions: [ OK ] 12.46 sec. 2024-07-22 21:47:54 01599_mutation_query_params: [ OK ] 20.50 sec. 2024-07-22 21:47:55 01568_window_functions_distributed: [ OK ] 5.12 sec. 2024-07-22 21:47:55 01581_deduplicate_by_columns_local: [ OK ] 5.96 sec. 2024-07-22 21:47:57 01561_aggregate_functions_of_key_with_join: [ OK ] 3.51 sec. 2024-07-22 21:47:59 01558_enum_as_num_in_tsv_csv_input: [ OK ] 3.72 sec. 2024-07-22 21:48:01 01561_mann_whitney_scipy: [ OK ] 6.80 sec. 2024-07-22 21:48:01 01533_collate_in_nullable: [ OK ] 3.87 sec. 2024-07-22 21:48:03 01528_play: [ OK ] 4.15 sec. 2024-07-22 21:48:05 01528_allow_nondeterministic_optimize_skip_unused_shards: [ OK ] 3.80 sec. 2024-07-22 21:48:05 01525_select_with_offset_fetch_clause: [ OK ] 3.78 sec. 2024-07-22 21:48:09 01519_topK_distributed_parametrized: [ OK ] 3.90 sec. 2024-07-22 21:48:12 01520_client_print_query_id: [ OK ] 7.40 sec. 2024-07-22 21:48:14 01515_force_data_skipping_indices: [ OK ] 4.37 sec. 2024-07-22 21:48:16 01514_input_format_tsv_enum_as_number_setting: [ OK ] 3.64 sec. 2024-07-22 21:48:16 01550_query_identifier_parameters: [ OK ] 20.63 sec. 2024-07-22 21:48:18 01514_empty_buffer_different_types: [ OK ] 3.90 sec. 2024-07-22 21:48:19 01512_create_replicate_merge_tree_one_arg: [ OK ] 3.16 sec. 2024-07-22 21:48:20 01511_alter_version_versioned_collapsing_merge_tree: [ OK ] 3.75 sec. 2024-07-22 21:48:22 01523_client_local_queries_file_parameter: [ OK ] 18.67 sec. 2024-07-22 21:48:22 01583_parallel_parsing_exception_with_offset: [ OK ] 36.93 sec. 2024-07-22 21:48:27 01508_query_obfuscator: [ OK ] 4.91 sec. 2024-07-22 21:48:27 01509_dictionary_preallocate: [ OK ] 7.50 sec. 2024-07-22 21:48:31 01503_if_const_optimization: [ OK ] 3.20 sec. 2024-07-22 21:48:31 01505_distributed_local_type_conversion_enum: [ OK ] 4.35 sec. 2024-07-22 21:48:34 01655_plan_optimizations_optimize_read_in_window_order_long: [ OK ] 89.44 sec. 2024-07-22 21:48:35 01502_bar_overflow: [ OK ] 4.01 sec. 2024-07-22 21:48:36 01508_format_regexp_raw: [ OK ] 13.73 sec. 2024-07-22 21:48:37 01496_signedness_conversion_monotonicity: [ OK ] 3.57 sec. 2024-07-22 21:48:39 01493_table_function_null: [ OK ] 3.24 sec. 2024-07-22 21:48:39 01485_256_bit_multiply: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:48:39 01502_jemalloc_percpu_arena: [ OK ] 8.26 sec. 2024-07-22 21:48:39 01492_array_join_crash_13829: [ OK ] 3.37 sec. 2024-07-22 21:48:41 01490_nullable_string_to_enum: [ OK ] 3.72 sec. 2024-07-22 21:48:42 01509_check_parallel_quorum_inserts_long: [ OK ] 24.15 sec. 2024-07-22 21:48:44 01473_system_events_zeroes: [ OK ] 4.48 sec. 2024-07-22 21:48:44 01476_right_full_join_switch: [ OK ] 5.76 sec. 2024-07-22 21:48:46 01475_read_subcolumns_2: [ OK ] 6.88 sec. 2024-07-22 21:48:50 01472_many_rows_in_totals: [ OK ] 9.09 sec. 2024-07-22 21:48:51 01630_simple_aggregate_all_functions_in_aggregating_merge_tree: [ OK ] 90.50 sec. 2024-07-22 21:48:51 01470_columns_transformers2: [ OK ] 8.86 sec. 2024-07-22 21:48:51 01456_min_negative_decimal_formatting: [ OK ] 6.83 sec. 2024-07-22 21:48:51 01463_resample_overflow: [ OK ] 7.48 sec. 2024-07-22 21:48:53 01456_low_cardinality_sorting_bugfix: [ OK ] 6.80 sec. 2024-07-22 21:48:54 01455_default_compression: [ OK ] 3.11 sec. 2024-07-22 21:48:54 01452_normalized_query_hash: [ OK ] 3.51 sec. 2024-07-22 21:48:55 01453_fixsed_string_sort: [ OK ] 3.80 sec. 2024-07-22 21:48:55 01434_netloc_fuzz: [ OK ] 3.22 sec. 2024-07-22 21:48:55 01450_set_null_const: [ OK ] 3.60 sec. 2024-07-22 21:48:56 01430_moving_sum_empty_state: [ OK ] 3.48 sec. 2024-07-22 21:48:58 01427_pk_and_expression_with_different_type: [ OK ] 3.56 sec. 2024-07-22 21:48:58 01421_array_nullable_element_nullable_index: [ OK ] 3.52 sec. 2024-07-22 21:48:59 01425_decimal_parse_big_negative_exponent: [ OK ] 3.93 sec. 2024-07-22 21:48:59 01418_custom_settings: [ OK ] 4.06 sec. 2024-07-22 21:48:59 01428_nullable_asof_join: [ OK ] 5.47 sec. 2024-07-22 21:49:00 01418_index_analysis_bug: [ OK ] 4.03 sec. 2024-07-22 21:49:02 01413_allow_non_metadata_alters: [ OK ] 3.00 sec. 2024-07-22 21:49:02 01416_join_totals_header_bug: [ OK ] 4.06 sec. 2024-07-22 21:49:03 01412_mod_float: [ OK ] 3.53 sec. 2024-07-22 21:49:04 01412_optimize_deduplicate_bug: [ OK ] 3.68 sec. 2024-07-22 21:49:06 01407_lambda_arrayJoin: [ OK ] 3.47 sec. 2024-07-22 21:49:06 01396_low_cardinality_fixed_string_default: [ OK ] 3.55 sec. 2024-07-22 21:49:06 01402_cast_nullable_string_to_enum: [ OK ] 3.99 sec. 2024-07-22 21:49:08 01384_bloom_filter_bad_arguments: [ OK ] 3.92 sec. 2024-07-22 21:49:09 01414_low_cardinality_nullable: [ OK ] 10.10 sec. 2024-07-22 21:49:10 01381_for_each_with_states: [ OK ] 3.92 sec. 2024-07-22 21:49:10 01380_coded_delta_exception_code: [ OK ] 3.80 sec. 2024-07-22 21:49:10 01378_alter_rename_with_ttl_zookeeper: [ OK ] 4.14 sec. 2024-07-22 21:49:12 01375_storage_file_write_prefix_tsv_with_names: [ OK ] 3.82 sec. 2024-07-22 21:49:13 01377_supertype_low_cardinality: [ OK ] 4.89 sec. 2024-07-22 21:49:13 01358_constexpr_constraint: [ OK ] 3.60 sec. 2024-07-22 21:49:14 01351_parse_date_time_best_effort_us: [ OK ] 3.55 sec. 2024-07-22 21:49:14 01349_mutation_datetime_key: [ OK ] 3.81 sec. 2024-07-22 21:49:16 01347_partition_date_vs_datetime: [ OK ] 3.59 sec. 2024-07-22 21:49:17 01338_sha256_fixedstring: [ OK ] 3.62 sec. 2024-07-22 21:49:18 01330_array_join_in_higher_order_function: [ OK ] 3.30 sec. 2024-07-22 21:49:18 01332_join_type_syntax_position: [ OK ] 4.48 sec. 2024-07-22 21:49:19 01340_datetime64_fpe: [ OK ] 5.56 sec. 2024-07-22 21:49:19 01324_settings_documentation: [ OK ] 3.32 sec. 2024-07-22 21:49:21 01322_cast_keep_nullable: [ OK ] 3.59 sec. 2024-07-22 21:49:22 01321_monotonous_functions_in_order_by_bug: [ OK ] 3.39 sec. 2024-07-22 21:49:23 01323_redundant_functions_in_order_by: [ OK ] 5.72 sec. 2024-07-22 21:49:24 01319_mv_constants_bug: [ OK ] 4.30 sec. 2024-07-22 21:49:25 01318_alter_add_column_exists: [ OK ] 2.94 sec. 2024-07-22 21:49:26 01417_query_time_in_system_events: [ OK ] 27.75 sec. 2024-07-22 21:49:26 01319_query_formatting_in_server_log: [ OK ] 7.36 sec. 2024-07-22 21:49:26 01314_position_in_system_columns: [ OK ] 3.74 sec. 2024-07-22 21:49:27 01318_map_add_map_subtract: [ OK ] 5.35 sec. 2024-07-22 21:49:27 01310_enum_comparison: [ OK ] 3.63 sec. 2024-07-22 21:49:28 01308_row_policy_and_trivial_count_query: [ OK ] 3.71 sec. 2024-07-22 21:49:29 01307_polygon_perimeter: [ OK ] 3.29 sec. 2024-07-22 21:49:30 01305_nullable-prewhere_bug: [ OK ] 4.23 sec. 2024-07-22 21:49:30 01299_alter_merge_tree: [ OK ] 3.66 sec. 2024-07-22 21:49:31 01297_alter_distributed: [ OK ] 3.38 sec. 2024-07-22 21:49:32 01509_check_many_parallel_quorum_inserts_long: [ OK ] 72.77 sec. 2024-07-22 21:49:32 01293_external_sorting_limit_bug: [ OK ] 3.93 sec. 2024-07-22 21:49:33 01292_optimize_data_skip_idx_order_by_expr: [ OK ] 3.63 sec. 2024-07-22 21:49:34 01292_quantile_array_bug: [ OK ] 3.36 sec. 2024-07-22 21:49:34 01291_geo_types: [ OK ] 3.51 sec. 2024-07-22 21:49:36 01285_data_skip_index_over_aggregation: [ OK ] 3.91 sec. 2024-07-22 21:49:36 01290_empty_array_index_analysis: [ OK ] 4.81 sec. 2024-07-22 21:49:36 01280_null_in: [ OK ] 3.56 sec. 2024-07-22 21:49:36 01281_alter_rename_and_other_renames: [ OK ] 3.90 sec. 2024-07-22 21:49:37 01278_alter_rename_combination: [ OK ] 3.13 sec. 2024-07-22 21:49:39 01277_alter_rename_column_constraint: [ OK ] 5.09 sec. 2024-07-22 21:49:40 01275_alter_rename_column_default_expr: [ OK ] 4.07 sec. 2024-07-22 21:49:41 01277_alter_rename_column_constraint_zookeeper_long: [ OK ] 4.92 sec. 2024-07-22 21:49:42 01277_random_fixed_string: [ OK ] 6.37 sec. 2024-07-22 21:49:42 01276_random_string: [ OK ] 6.02 sec. 2024-07-22 21:49:43 01271_show_privileges: [ OK ] 3.54 sec. 2024-07-22 21:49:44 01260_ubsan_decimal_parse: [ OK ] 3.35 sec. 2024-07-22 21:49:44 01269_toStartOfSecond: [ OK ] 3.99 sec. 2024-07-22 21:49:46 01248_least_greatest_mixed_const: [ OK ] 3.35 sec. 2024-07-22 21:49:46 01259_combinator_distinct: [ OK ] 4.30 sec. 2024-07-22 21:49:48 01240_join_get_or_null: [ OK ] 3.90 sec. 2024-07-22 21:49:48 01232_untuple: [ OK ] 3.85 sec. 2024-07-22 21:49:49 01626_cnf_fuzz_long: [ OK ] 146.78 sec. 2024-07-22 21:49:49 01252_weird_time_zone: [ OK ] 6.89 sec. 2024-07-22 21:49:50 01226_dist_on_dist_global_in: [ OK ] 3.95 sec. 2024-07-22 21:49:52 01213_alter_rename_nested: [ OK ] 3.60 sec. 2024-07-22 21:49:53 01213_alter_rename_with_default_zookeeper_long: [ OK ] 3.76 sec. 2024-07-22 21:49:53 01213_optimize_skip_unused_shards_DISTINCT: [ OK ] 4.17 sec. 2024-07-22 21:49:54 01210_drop_view: [ OK ] 3.37 sec. 2024-07-22 21:49:55 01271_optimize_arithmetic_operations_in_aggr_func_long: [ OK ] 18.10 sec. 2024-07-22 21:49:56 01202_array_auc_special: [ OK ] 3.91 sec. 2024-07-22 21:49:59 01181_db_atomic_drop_on_cluster: [ OK ] 4.17 sec. 2024-07-22 21:49:59 01231_operator_null_in: [ OK ] 13.32 sec. 2024-07-22 21:50:02 01182_materialized_view_different_structure: [ OK ] 8.17 sec. 2024-07-22 21:50:05 01179_insert_values_semicolon: [ OK ] 8.76 sec. 2024-07-22 21:50:13 01161_information_schema: [ OK ] 14.09 sec. 2024-07-22 21:50:15 01201_read_single_thread_in_order: [ OK ] 22.14 sec. 2024-07-22 21:50:17 01151_storage_merge_filter_tables_by_virtual_column: [ OK ] 14.53 sec. 2024-07-22 21:50:20 01135_default_and_alter_zookeeper: [ OK ] 4.14 sec. 2024-07-22 21:50:20 01142_with_ties_and_aliases: [ OK ] 6.17 sec. 2024-07-22 21:50:20 01146_clickhouse_local_data: [ OK ] 15.45 sec. 2024-07-22 21:50:22 01128_generate_random_nested: [ OK ] 5.40 sec. 2024-07-22 21:50:23 01117_greatest_least_case: [ OK ] 3.29 sec. 2024-07-22 21:50:23 01126_month_partitioning_consistent_code: [ OK ] 3.61 sec. 2024-07-22 21:50:24 01114_clear_column_compact_parts: [ OK ] 3.83 sec. 2024-07-22 21:50:26 01106_const_fixed_string_like: [ OK ] 4.33 sec. 2024-07-22 21:50:27 01102_distributed_local_in_bug: [ OK ] 4.21 sec. 2024-07-22 21:50:27 01105_string_like: [ OK ] 4.41 sec. 2024-07-22 21:50:30 01099_operators_date_and_timestamp: [ OK ] 5.60 sec. 2024-07-22 21:50:30 01096_array_reduce_in_ranges: [ OK ] 3.53 sec. 2024-07-22 21:50:32 01184_long_insert_values_huge_strings: [ OK ] 38.87 sec. 2024-07-22 21:50:33 01087_table_function_generate: [ OK ] 5.22 sec. 2024-07-22 21:50:33 01081_keywords_formatting: [ OK ] 3.31 sec. 2024-07-22 21:50:33 01083_match_zero_byte: [ OK ] 3.69 sec. 2024-07-22 21:50:36 01080_check_for_error_incorrect_size_of_nested_column: [ OK ] 3.79 sec. 2024-07-22 21:50:37 01080_engine_merge_prewhere_tupleelement_error: [ OK ] 3.91 sec. 2024-07-22 21:50:40 01074_h3_range_check: [ OK ] 3.51 sec. 2024-07-22 21:50:42 01213_alter_rename_column_zookeeper_long: [ OK ] 53.69 sec. 2024-07-22 21:50:47 01072_json_each_row_data_in_square_brackets: [ OK ] 4.51 sec. 2024-07-22 21:50:48 01073_blockSerializedSize: [ OK ] 7.83 sec. 2024-07-22 21:50:48 01086_regexp_input_format_skip_unmatched: [ OK ] 20.56 sec. 2024-07-22 21:50:51 01304_direct_io_long: [ OK ] 84.55 sec. 2024-07-22 21:50:52 01065_if_not_finite: [ OK ] 3.68 sec. 2024-07-22 21:50:52 01071_force_optimize_skip_unused_shards: [ OK ] 5.33 sec. 2024-07-22 21:50:54 01063_create_column_set: [ OK ] 3.41 sec. 2024-07-22 21:50:56 01062_pm_multiple_all_join_same_value: [ OK ] 3.58 sec. 2024-07-22 21:51:01 01062_alter_on_mutataion_zookeeper_long: [ OK ] 6.43 sec. 2024-07-22 21:51:05 01058_zlib_ng_level1_bug: [ OK ] 9.08 sec. 2024-07-22 21:51:10 01057_http_compression_prefer_brotli: [ OK ] 5.40 sec. 2024-07-22 21:51:12 01077_mutations_index_consistency: [ OK ] 38.65 sec. 2024-07-22 21:51:13 01066_window_view_event_tumble_to_strict_asc_lateness: [ OK ] 24.55 sec. 2024-07-22 21:51:16 01076_window_view_alter_query_to: [ OK ] 39.86 sec. 2024-07-22 21:51:16 01063_window_view_event_tumble_to_bounded: [ OK ] 24.46 sec. 2024-07-22 21:51:17 01053_if_chain_check: [ OK ] 3.89 sec. 2024-07-22 21:51:19 01051_random_printable_ascii: [ OK ] 3.27 sec. 2024-07-22 21:51:20 01079_bad_alters_zookeeper_long: [ OK ] 46.05 sec. 2024-07-22 21:51:21 01050_engine_join_view_crash: [ OK ] 4.39 sec. 2024-07-22 21:51:23 01049_join_low_card_crash: [ OK ] 3.97 sec. 2024-07-22 21:51:24 01047_simple_aggregate_sizes_of_columns_bug: [ OK ] 4.72 sec. 2024-07-22 21:51:26 01047_window_view_parser_inner_table: [ OK ] 4.81 sec. 2024-07-22 21:51:26 01058_window_view_event_hop_to_strict_asc: [ OK ] 25.08 sec. 2024-07-22 21:51:27 01046_materialized_view_with_join_over_distributed: [ OK ] 4.26 sec. 2024-07-22 21:51:28 01041_create_dictionary_if_not_exists: [ OK ] 3.53 sec. 2024-07-22 21:51:30 01039_test_setting_parse: [ OK ] 3.91 sec. 2024-07-22 21:51:31 01036_union_different_columns: [ OK ] 3.23 sec. 2024-07-22 21:51:33 01039_row_policy_dcl: [ OK ] 7.26 sec. 2024-07-22 21:51:34 01032_cityHash64_for_UUID: [ OK ] 4.06 sec. 2024-07-22 21:51:35 01055_compact_parts_granularity: [ OK ] 24.72 sec. 2024-07-22 21:51:36 01030_storage_hdfs_syntax: [ OK ] 3.35 sec. 2024-07-22 21:51:38 01029_early_constant_folding: [ OK ] 3.47 sec. 2024-07-22 21:51:39 01021_only_tuple_columns: [ OK ] 3.99 sec. 2024-07-22 21:51:40 01020_function_char: [ OK ] 3.32 sec. 2024-07-22 21:51:40 01019_alter_materialized_view_atomic: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:51:41 01020_function_array_compact: [ OK ] 3.65 sec. 2024-07-22 21:51:44 01018_ambiguous_column: [ OK ] 3.87 sec. 2024-07-22 21:51:45 01054_cache_dictionary_bunch_update: [ OK ] 33.23 sec. 2024-07-22 21:51:52 01030_limit_by_with_ties_error: [ OK ] 21.25 sec. 2024-07-22 21:51:57 01012_show_tables_limit: [ OK ] 10.92 sec. 2024-07-22 21:51:59 01015_empty_in_inner_right_join: [ OK ] 15.48 sec. 2024-07-22 21:52:00 01012_select_limit_x_0: [ OK ] 7.99 sec. 2024-07-22 21:52:03 01011_test_create_as_skip_indices: [ OK ] 3.85 sec. 2024-07-22 21:52:05 01012_serialize_array_memory_usage: [ OK ] 8.42 sec. 2024-07-22 21:52:12 01010_partial_merge_join_const_and_lc: [ OK ] 11.22 sec. 2024-07-22 21:52:16 01009_global_array_join_names: [ OK ] 10.60 sec. 2024-07-22 21:52:17 01010_partial_merge_join_negative: [ OK ] 13.54 sec. 2024-07-22 21:52:17 01009_insert_select_data_loss: [ OK ] 5.84 sec. 2024-07-22 21:52:18 01049_join_low_card_bug_long: [ OK ] 60.86 sec. 2024-07-22 21:52:20 01008_materialized_view_henyihanwobushi: [ OK ] 4.14 sec. 2024-07-22 21:52:21 01001_enums_in_in_section: [ OK ] 3.49 sec. 2024-07-22 21:52:22 01006_ttl_with_default_2: [ OK ] 5.07 sec. 2024-07-22 21:52:22 00999_join_on_expression: [ OK ] 4.81 sec. 2024-07-22 21:52:23 01035_enum_conversion_native_format: [ OK ] 54.76 sec. 2024-07-22 21:52:24 00999_join_not_nullable_types: [ OK ] 3.58 sec. 2024-07-22 21:52:25 00999_test_skip_indices_with_alter_and_merge: [ OK ] 3.54 sec. 2024-07-22 21:52:25 00980_alter_settings_race: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:52:26 00988_expansion_aliases_limit: [ OK ] 3.21 sec. 2024-07-22 21:52:28 00979_set_index_not: [ OK ] 3.68 sec. 2024-07-22 21:52:29 00997_trim: [ OK ] 7.28 sec. 2024-07-22 21:52:29 00986_materialized_view_stack_overflow: [ OK ] 5.27 sec. 2024-07-22 21:52:29 00978_ml_math: [ OK ] 3.44 sec. 2024-07-22 21:52:32 01156_pcg_deserialization: [ OK ] 152.18 sec. 2024-07-22 21:52:32 00977_int_div: [ OK ] 3.97 sec. 2024-07-22 21:52:33 00971_merge_tree_uniform_read_distribution_and_max_rows_to_read: [ OK ] 3.79 sec. 2024-07-22 21:52:34 01019_alter_materialized_view_consistent: [ OK ] 55.19 sec. 2024-07-22 21:52:35 00969_roundDuration: [ OK ] 3.67 sec. 2024-07-22 21:52:36 00972_geohashesInBox: [ OK ] 7.16 sec. 2024-07-22 21:52:37 00964_os_thread_priority: [ OK ] 3.19 sec. 2024-07-22 21:52:37 00974_adaptive_granularity_secondary_index: [ OK ] 8.30 sec. 2024-07-22 21:52:38 00961_checksums_in_system_parts_columns_table: [ OK ] 2.59 sec. 2024-07-22 21:52:40 00957_coalesce_const_nullable_crash: [ OK ] 3.71 sec. 2024-07-22 21:52:40 00995_exception_while_insert: [ OK ] 17.77 sec. 2024-07-22 21:52:40 01017_mutations_with_nondeterministic_functions_zookeeper: [ OK ] 59.00 sec. 2024-07-22 21:52:42 00956_http_prepared_statements: [ OK ] 4.32 sec. 2024-07-22 21:52:44 00952_insert_into_distributed_with_materialized_column: [ OK ] 5.77 sec. 2024-07-22 21:52:44 00950_default_prewhere: [ OK ] 3.90 sec. 2024-07-22 21:52:45 00948_values_interpreter_template: [ OK ] 4.52 sec. 2024-07-22 21:52:46 00945_ml_test: [ OK ] 3.83 sec. 2024-07-22 21:52:48 00942_mv_rename_table: [ OK ] 3.88 sec. 2024-07-22 21:52:49 00940_max_parts_in_total: [ OK ] 3.81 sec. 2024-07-22 21:52:50 00951_ngram_search: [ OK ] 9.68 sec. 2024-07-22 21:52:51 00940_order_by_read_in_order: [ OK ] 5.24 sec. 2024-07-22 21:52:52 00938_ipv6_cidr_range: [ OK ] 4.32 sec. 2024-07-22 21:53:03 00955_test_final_mark_use: [ OK ] 25.27 sec. 2024-07-22 21:53:04 00936_substring_utf8_non_const: [ OK ] 11.14 sec. 2024-07-22 21:53:07 00931_low_cardinality_set_index_in_key_condition: [ OK ] 3.58 sec. 2024-07-22 21:53:09 00937_template_output_format: [ OK ] 19.59 sec. 2024-07-22 21:53:11 00931_low_cardinality_read_with_empty_array: [ OK ] 4.06 sec. 2024-07-22 21:53:14 00930_arrayIntersect: [ OK ] 4.43 sec. 2024-07-22 21:53:18 00919_histogram_merge: [ OK ] 3.68 sec. 2024-07-22 21:53:21 00937_format_schema_rows_template: [ OK ] 30.19 sec. 2024-07-22 21:53:24 00927_asof_join_long: [ OK ] 12.46 sec. 2024-07-22 21:53:25 00917_least_sqr: [ OK ] 3.54 sec. 2024-07-22 21:53:28 00918_json_functions: [ OK ] 10.78 sec. 2024-07-22 21:53:31 00910_zookeeper_custom_compression_codecs_replicated_long: [ OK ] 7.05 sec. 2024-07-22 21:53:32 00965_shard_unresolvable_addresses: [ OK ] 59.34 sec. 2024-07-22 21:53:32 00906_low_cardinality_const_argument: [ OK ] 3.36 sec. 2024-07-22 21:53:35 00905_field_with_aggregate_function_state: [ OK ] 3.55 sec. 2024-07-22 21:53:35 00903_array_with_constant_function: [ OK ] 3.37 sec. 2024-07-22 21:53:36 00902_entropy: [ OK ] 4.51 sec. 2024-07-22 21:53:40 00900_entropy_shard: [ OK ] 3.65 sec. 2024-07-22 21:53:43 00933_ttl_replicated_zookeeper: [ OK ] 40.54 sec. 2024-07-22 21:53:46 00937_test_use_header_csv: [ OK ] 56.90 sec. 2024-07-22 21:53:48 00875_join_right_nulls: [ OK ] 7.58 sec. 2024-07-22 21:53:49 00861_decimal_quoted_csv: [ OK ] 3.55 sec. 2024-07-22 21:53:51 00860_unknown_identifier_bug: [ OK ] 3.65 sec. 2024-07-22 21:53:52 00870_t64_codec: [ OK ] 8.60 sec. 2024-07-22 21:53:53 00944_create_bloom_filter_index_with_merge_tree: [ OK ] 68.79 sec. 2024-07-22 21:53:53 00856_no_column_issue_4242: [ OK ] 3.84 sec. 2024-07-22 21:53:55 00852_any_join_nulls: [ OK ] 3.62 sec. 2024-07-22 21:53:56 00842_array_with_constant_overflow: [ OK ] 3.17 sec. 2024-07-22 21:53:56 00843_optimize_predicate_and_rename_table: [ OK ] 3.77 sec. 2024-07-22 21:53:58 00850_global_join_dups: [ OK ] 5.48 sec. 2024-07-22 21:53:59 00841_temporary_table_database: [ OK ] 3.52 sec. 2024-07-22 21:54:00 00836_indices_alter: [ OK ] 3.81 sec. 2024-07-22 21:54:01 00834_limit_with_constant_expressions: [ OK ] 4.52 sec. 2024-07-22 21:54:01 00900_orc_nested_arrays_load: [ OK ] 26.65 sec. 2024-07-22 21:54:01 00832_storage_file_lock: [ OK ] 3.64 sec. 2024-07-22 21:54:03 00829_bitmap64_function: [ OK ] 4.42 sec. 2024-07-22 21:54:07 00804_test_custom_compression_codes_log_storages: [ OK ] 5.55 sec. 2024-07-22 21:54:08 00802_system_parts_with_datetime_partition: [ OK ] 4.83 sec. 2024-07-22 21:54:11 00762_date_comparsion: [ OK ] 4.05 sec. 2024-07-22 21:54:12 00758_array_reverse: [ OK ] 3.90 sec. 2024-07-22 21:54:14 00757_enum_defaults_const_analyzer: [ OK ] 3.47 sec. 2024-07-22 21:54:19 00754_alter_modify_column_partitions: [ OK ] 4.61 sec. 2024-07-22 21:54:21 00825_protobuf_format_squares: [ OK ] 20.79 sec. 2024-07-22 21:54:22 00825_protobuf_format_array_of_arrays: [ OK ] 20.64 sec. 2024-07-22 21:54:23 00753_alter_destination_for_storage_buffer: [ OK ] 4.34 sec. 2024-07-22 21:54:24 00964_bloom_index_string_functions: [ OK ] 110.66 sec. 2024-07-22 21:54:25 00749_inner_join_of_unnamed_subqueries: [ OK ] 3.85 sec. 2024-07-22 21:54:26 00740_database_in_nested_view: [ OK ] 4.08 sec. 2024-07-22 21:54:27 00738_nested_merge_multidimensional_array: [ OK ] 3.88 sec. 2024-07-22 21:54:28 00732_quorum_insert_lost_part_zookeeper_long: [ OK ] 4.23 sec. 2024-07-22 21:54:28 00825_protobuf_format_no_length_delimiter: [ OK ] 27.22 sec. 2024-07-22 21:54:29 00732_quorum_insert_select_with_old_data_and_without_quorum_zookeeper_long: [ OK ] 4.21 sec. 2024-07-22 21:54:31 00732_quorum_insert_lost_part_and_alive_part_zookeeper_long: [ OK ] 4.79 sec. 2024-07-22 21:54:32 00900_orc_arrow_parquet_maps: [ OK ] 56.33 sec. 2024-07-22 21:54:32 00726_length_aliases: [ OK ] 3.38 sec. 2024-07-22 21:54:32 00729_prewhere_array_join: [ OK ] 4.49 sec. 2024-07-22 21:54:33 00725_comment_columns_long: [ OK ] 3.32 sec. 2024-07-22 21:54:35 00713_collapsing_merge_tree: [ OK ] 3.72 sec. 2024-07-22 21:54:36 00717_low_cardinaliry_group_by: [ OK ] 5.12 sec. 2024-07-22 21:54:37 00712_prewhere_with_alias: [ OK ] 4.56 sec. 2024-07-22 21:54:37 00717_low_cardinaliry_distributed_group_by: [ OK ] 5.15 sec. 2024-07-22 21:54:37 00712_nan_comparison: [ OK ] 4.41 sec. 2024-07-22 21:54:39 00712_prewhere_with_missing_columns: [ OK ] 3.75 sec. 2024-07-22 21:54:40 00709_virtual_column_partition_id: [ OK ] 3.58 sec. 2024-07-22 21:54:41 00702_join_with_using: [ OK ] 4.44 sec. 2024-07-22 21:54:44 00700_decimal_in_keys: [ OK ] 4.39 sec. 2024-07-22 21:54:44 00700_decimal_math: [ OK ] 4.31 sec. 2024-07-22 21:54:48 00704_drop_truncate_memory_table: [ OK ] 11.02 sec. 2024-07-22 21:54:48 00700_decimal_round: [ OK ] 6.94 sec. 2024-07-22 21:54:50 00728_json_each_row_parsing: [ OK ] 22.04 sec. 2024-07-22 21:54:51 00698_validate_array_sizes_for_nested: [ OK ] 3.57 sec. 2024-07-22 21:54:52 00700_decimal_casts: [ OK ] 8.19 sec. 2024-07-22 21:54:54 00697_in_subquery_shard: [ OK ] 5.31 sec. 2024-07-22 21:54:54 00696_system_columns_limit: [ OK ] 4.05 sec. 2024-07-22 21:54:55 00689_join_table_function: [ OK ] 3.37 sec. 2024-07-22 21:54:57 00688_case_without_else: [ OK ] 3.42 sec. 2024-07-22 21:54:57 00688_low_cardinality_syntax: [ OK ] 5.57 sec. 2024-07-22 21:55:00 00678_shard_funnel_window: [ OK ] 4.74 sec. 2024-07-22 21:55:01 00674_has_array_enum: [ OK ] 3.51 sec. 2024-07-22 21:55:03 00699_materialized_view_mutations: [ OK ] 19.07 sec. 2024-07-22 21:55:03 00668_compare_arrays_silviucpp: [ OK ] 3.64 sec. 2024-07-22 21:55:06 00666_uniq_complex_types: [ OK ] 5.29 sec. 2024-07-22 21:55:07 00647_select_numbers_with_offset: [ OK ] 3.28 sec. 2024-07-22 21:55:10 00646_weird_mmx: [ OK ] 3.41 sec. 2024-07-22 21:55:10 00645_date_time_input_format: [ OK ] 3.39 sec. 2024-07-22 21:55:15 00626_in_syntax: [ OK ] 4.47 sec. 2024-07-22 21:55:24 00673_subquery_prepared_set_performance: [ OK ] 26.92 sec. 2024-07-22 21:55:29 00705_drop_create_merge_tree: [ OK ] 52.20 sec. 2024-07-22 21:55:29 00625_arrays_in_nested: [ OK ] 4.66 sec. 2024-07-22 21:55:33 00619_extract: [ OK ] 3.81 sec. 2024-07-22 21:55:37 00617_array_in: [ OK ] 4.40 sec. 2024-07-22 21:55:42 00612_http_max_query_size_for_distributed: [ OK ] 4.17 sec. 2024-07-22 21:55:44 00754_distributed_optimize_skip_select_on_unused_shards: [ OK ] 92.04 sec. 2024-07-22 21:55:45 00608_uniq_array: [ OK ] 3.69 sec. 2024-07-22 21:55:49 00593_union_all_assert_columns_removed: [ OK ] 3.92 sec. 2024-07-22 21:55:53 00592_union_all_different_aliases: [ OK ] 3.49 sec. 2024-07-22 21:55:56 00591_columns_removal_union_all: [ OK ] 3.52 sec. 2024-07-22 21:55:57 00625_summing_merge_tree_merge: [ OK ] 28.18 sec. 2024-07-22 21:55:58 00632_get_sample_block_cache: [ OK ] 48.65 sec. 2024-07-22 21:56:01 00586_removing_unused_columns_from_subquery: [ OK ] 4.31 sec. 2024-07-22 21:56:01 00578_merge_table_shadow_virtual_column: [ OK ] 3.96 sec. 2024-07-22 21:56:02 00568_empty_function_with_fixed_string: [ OK ] 3.61 sec. 2024-07-22 21:56:04 00559_filter_array_generic: [ OK ] 3.33 sec. 2024-07-22 21:56:05 00563_complex_in_expression: [ OK ] 3.89 sec. 2024-07-22 21:56:07 00554_nested_and_table_engines: [ OK ] 4.90 sec. 2024-07-22 21:56:08 00551_parse_or_null: [ OK ] 3.45 sec. 2024-07-22 21:56:08 00547_named_tuples: [ OK ] 3.43 sec. 2024-07-22 21:56:10 00546_shard_tuple_element_formatting: [ OK ] 3.54 sec. 2024-07-22 21:56:10 00534_functions_bad_arguments11: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:56:10 00534_functions_bad_arguments12: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:56:10 00534_functions_bad_arguments2: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:56:12 00543_null_and_prewhere: [ OK ] 3.65 sec. 2024-07-22 21:56:12 00539_functions_for_working_with_json: [ OK ] 3.86 sec. 2024-07-22 21:56:14 00532_topk_generic: [ OK ] 3.49 sec. 2024-07-22 21:56:15 00531_aggregate_over_nullable: [ OK ] 3.85 sec. 2024-07-22 21:56:18 00530_arrays_of_nothing: [ OK ] 3.78 sec. 2024-07-22 21:56:19 00525_aggregate_functions_of_nullable_that_return_non_nullable: [ OK ] 3.45 sec. 2024-07-22 21:56:21 00523_aggregate_functions_in_group_array: [ OK ] 3.59 sec. 2024-07-22 21:56:23 00520_tuple_values_interpreter: [ OK ] 3.57 sec. 2024-07-22 21:56:26 00531_client_ignore_error: [ OK ] 14.02 sec. 2024-07-22 21:56:26 00515_shard_desc_table_functions_and_subqueries: [ OK ] 3.89 sec. 2024-07-22 21:56:27 00517_date_parsing: [ OK ] 5.17 sec. 2024-07-22 21:56:29 00908_bloom_filter_index: [ OK ] 184.38 sec. 2024-07-22 21:56:32 00504_mergetree_arrays_rw: [ OK ] 4.86 sec. 2024-07-22 21:56:32 00602_throw_if: [ OK ] 48.25 sec. 2024-07-22 21:56:35 00505_secure: [ OK ] 8.81 sec. 2024-07-22 21:56:36 00501_http_head: [ OK ] 4.11 sec. 2024-07-22 21:56:36 00502_sum_map: [ OK ] 6.97 sec. 2024-07-22 21:56:37 00652_mergetree_mutations: [ OK ] 94.03 sec. 2024-07-22 21:56:39 00498_bitwise_aggregate_functions: [ OK ] 4.01 sec. 2024-07-22 21:56:40 00500_point_in_polygon_non_const_poly: [ OK ] 7.41 sec. 2024-07-22 21:56:40 00507_array_no_params: [ OK ] 13.68 sec. 2024-07-22 21:56:41 00490_with_select: [ OK ] 3.58 sec. 2024-07-22 21:56:43 00488_non_ascii_column_names: [ OK ] 3.46 sec. 2024-07-22 21:56:43 00482_subqueries_and_aliases: [ OK ] 3.54 sec. 2024-07-22 21:56:44 00486_if_fixed_string: [ OK ] 3.88 sec. 2024-07-22 21:56:44 00481_create_view_for_null: [ OK ] 3.49 sec. 2024-07-22 21:56:46 00476_pretty_formats_and_widths: [ OK ] 3.50 sec. 2024-07-22 21:56:47 00470_identifiers_in_double_quotes: [ OK ] 3.34 sec. 2024-07-22 21:56:47 00464_array_element_out_of_range: [ OK ] 3.31 sec. 2024-07-22 21:56:50 00498_array_functions_concat_slice_push_pop: [ OK ] 14.00 sec. 2024-07-22 21:56:50 00439_fixed_string_filter: [ OK ] 3.44 sec. 2024-07-22 21:56:51 00447_foreach_modifier: [ OK ] 4.07 sec. 2024-07-22 21:56:51 00445_join_nullable_keys: [ OK ] 3.75 sec. 2024-07-22 21:56:52 00458_merge_type_cast: [ OK ] 7.16 sec. 2024-07-22 21:56:54 00436_convert_charset: [ OK ] 3.59 sec. 2024-07-22 21:56:55 00436_fixed_string_16_comparisons: [ OK ] 4.76 sec. 2024-07-22 21:56:55 00430_https_server: [ OK ] 3.99 sec. 2024-07-22 21:56:55 00424_shard_aggregate_functions_of_nullable: [ OK ] 4.29 sec. 2024-07-22 21:57:00 00409_shard_limit_by: [ OK ] 4.62 sec. 2024-07-22 21:57:03 00403_to_start_of_day: [ OK ] 3.38 sec. 2024-07-22 21:57:07 00399_group_uniq_array_date_datetime: [ OK ] 3.93 sec. 2024-07-22 21:57:11 00397_tsv_format_synonym: [ OK ] 3.61 sec. 2024-07-22 21:57:15 00394_new_nested_column_keeps_offsets: [ OK ] 3.91 sec. 2024-07-22 21:57:16 00419_show_sql_queries: [ OK ] 24.71 sec. 2024-07-22 21:57:18 00378_json_quote_64bit_integers: [ OK ] 3.92 sec. 2024-07-22 21:57:27 00375_shard_group_uniq_array_of_string: [ OK ] 8.93 sec. 2024-07-22 21:57:31 00411_long_accurate_number_comparison_int4: [ OK ] 36.26 sec. 2024-07-22 21:57:31 00497_whitespaces_in_insert: [ OK ] 54.86 sec. 2024-07-22 21:57:32 00373_group_by_tuple: [ OK ] 4.41 sec. 2024-07-22 21:57:33 00376_shard_group_uniq_array_of_int_array: [ OK ] 16.20 sec. 2024-07-22 21:57:34 00411_long_accurate_number_comparison_float: [ OK ] 39.89 sec. 2024-07-22 21:57:35 00364_java_style_denormals: [ OK ] 3.50 sec. 2024-07-22 21:57:36 00348_tuples: [ OK ] 4.30 sec. 2024-07-22 21:57:37 00347_has_tuple: [ OK ] 4.31 sec. 2024-07-22 21:57:38 00339_parsing_bad_arrays: [ OK ] 4.12 sec. 2024-07-22 21:57:38 00338_replicate_array_of_strings: [ OK ] 3.69 sec. 2024-07-22 21:57:41 00334_column_aggregate_function_limit: [ OK ] 3.68 sec. 2024-07-22 21:57:41 00333_parser_number_bug: [ OK ] 3.22 sec. 2024-07-22 21:57:45 00322_disable_checksumming: [ OK ] 4.02 sec. 2024-07-22 21:57:45 00354_host_command_line_option: [ OK ] 13.98 sec. 2024-07-22 21:57:46 00323_quantiles_timing_bug: [ OK ] 8.01 sec. 2024-07-22 21:57:48 00307_format_xml: [ OK ] 3.38 sec. 2024-07-22 21:57:49 00300_csv: [ OK ] 3.46 sec. 2024-07-22 21:57:51 00296_url_parameters: [ OK ] 4.46 sec. 2024-07-22 21:57:51 00336_shard_stack_trace: [ OK ] 14.56 sec. 2024-07-22 21:57:52 00291_array_reduce: [ OK ] 3.38 sec. 2024-07-22 21:57:54 00268_aliases_without_as_keyword: [ OK ] 3.32 sec. 2024-07-22 21:57:55 00267_tuple_array_access_operators_priority: [ OK ] 3.23 sec. 2024-07-22 21:57:57 00290_shard_aggregation_memory_efficient: [ OK ] 8.64 sec. 2024-07-22 21:57:58 00258_materializing_tuples: [ OK ] 3.51 sec. 2024-07-22 21:57:58 00282_merging: [ OK ] 7.22 sec. 2024-07-22 21:58:00 00257_shard_no_aggregates_and_constant_keys: [ OK ] 4.82 sec. 2024-07-22 21:58:02 00234_disjunctive_equality_chains_optimization: [ OK ] 3.51 sec. 2024-07-22 21:58:02 00236_replicated_drop_on_non_leader_zookeeper_long: [ OK ] 4.02 sec. 2024-07-22 21:58:03 00682_empty_parts_merge: [ OK ] 188.34 sec. 2024-07-22 21:58:04 00230_array_functions_has_count_equal_index_of_non_const_second_arg: [ OK ] 4.45 sec. 2024-07-22 21:58:05 00225_join_duplicate_columns: [ OK ] 3.62 sec. 2024-07-22 21:58:06 00240_replace_substring_loop: [ OK ] 8.60 sec. 2024-07-22 21:58:06 00220_shard_with_totals_in_subquery_remote_and_limit: [ OK ] 3.57 sec. 2024-07-22 21:58:07 00224_shard_distributed_aggregation_memory_efficient_and_overflows: [ OK ] 4.98 sec. 2024-07-22 21:58:08 00219_full_right_join_column_order: [ OK ] 3.63 sec. 2024-07-22 21:58:09 00214_primary_key_order: [ OK ] 3.79 sec. 2024-07-22 21:58:10 00200_shard_distinct_order_by_limit_distributed: [ OK ] 3.84 sec. 2024-07-22 21:58:10 00205_scalar_subqueries: [ OK ] 4.30 sec. 2024-07-22 21:58:12 00197_if_fixed_string: [ OK ] 3.70 sec. 2024-07-22 21:58:12 00199_ternary_operator_type_check: [ OK ] 5.07 sec. 2024-07-22 21:58:13 00196_float32_formatting: [ OK ] 3.57 sec. 2024-07-22 21:58:13 00155_long_merges: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 21:58:14 00191_aggregating_merge_tree_and_final: [ OK ] 3.75 sec. 2024-07-22 21:58:15 00167_settings_inside_query: [ OK ] 3.63 sec. 2024-07-22 21:58:15 00157_aliases_and_lambda_formal_parameters: [ OK ] 3.37 sec. 2024-07-22 21:58:16 00152_totals_in_subquery: [ OK ] 3.54 sec. 2024-07-22 21:58:17 00151_tuple_with_array: [ OK ] 3.34 sec. 2024-07-22 21:58:19 00145_empty_likes: [ OK ] 3.78 sec. 2024-07-22 21:58:20 00146_summing_merge_tree_nested_map: [ OK ] 4.32 sec. 2024-07-22 21:58:20 00140_prewhere_column_order: [ OK ] 3.59 sec. 2024-07-22 21:58:22 00121_drop_column_zookeeper: [ OK ] 4.51 sec. 2024-07-22 21:58:23 00119_storage_join: [ OK ] 3.89 sec. 2024-07-22 21:58:23 00114_float_type_result_of_division: [ OK ] 3.41 sec. 2024-07-22 21:58:26 00098_3_union_all: [ OK ] 3.82 sec. 2024-07-22 21:58:27 00098_6_union_all: [ OK ] 3.35 sec. 2024-07-22 21:58:27 00098_d_union_all: [ OK ] 3.88 sec. 2024-07-22 21:58:30 00089_group_by_arrays_of_fixed: [ OK ] 3.43 sec. 2024-07-22 21:58:31 00087_distinct_of_empty_arrays: [ OK ] 3.46 sec. 2024-07-22 21:58:34 00086_concat_nary_const_with_nonconst_segfault: [ OK ] 3.71 sec. 2024-07-22 21:58:34 00077_set_keys_fit_128_bits_many_blocks: [ OK ] 3.64 sec. 2024-07-22 21:58:36 00186_very_long_arrays: [ OK ] 25.52 sec. 2024-07-22 21:58:38 00056_join_number_string: [ OK ] 3.43 sec. 2024-07-22 21:58:38 00063_check_query: [ OK ] 3.87 sec. 2024-07-22 21:58:40 00048_b_stored_aggregates_merge: [ OK ] 4.01 sec. 2024-07-22 21:58:41 00044_sorting_by_string_descending: [ OK ] 3.47 sec. 2024-07-22 21:58:41 00034_fixed_string_to_number: [ OK ] 3.36 sec. 2024-07-22 21:58:43 00033_fixed_string_to_string: [ OK ] 3.33 sec. 2024-07-22 21:58:45 00023_agg_select_agg_subquery: [ OK ] 3.49 sec. 2024-07-22 21:58:45 00017_in_subquery_with_empty_result: [ OK ] 3.42 sec. 2024-07-22 21:58:47 00010_big_array_join: [ OK ] 3.30 sec. 2024-07-22 21:58:47 2024-07-22 21:58:47 Having 1 errors! 105 tests passed. 0 tests skipped. 1409.34 s elapsed (ForkPoolWorker-7). 2024-07-22 21:58:48 00003_reinterpret_as_string: [ OK ] 3.35 sec. 2024-07-22 21:58:48 2024-07-22 21:58:48 175 tests passed. 1 tests skipped. 1410.82 s elapsed (ForkPoolWorker-5). 2024-07-22 21:58:48 00001_select_1: [ OK ] 3.35 sec. 2024-07-22 21:58:48 2024-07-22 21:58:48 172 tests passed. 2 tests skipped. 1410.87 s elapsed (ForkPoolWorker-8). 2024-07-22 21:59:08 00312_position_case_insensitive_utf8: [ OK ] 86.55 sec. 2024-07-22 21:59:08 2024-07-22 21:59:08 119 tests passed. 0 tests skipped. 1430.78 s elapsed (ForkPoolWorker-9). 2024-07-22 21:59:19 00411_long_accurate_number_comparison_int1: [ OK ] 144.32 sec. 2024-07-22 21:59:19 2024-07-22 21:59:19 Having 1 errors! 158 tests passed. 5 tests skipped. 1441.62 s elapsed (ForkPoolWorker-6). 2024-07-22 21:59:30 00115_shard_in_incomplete_result: [ OK ] 69.87 sec. 2024-07-22 21:59:30 2024-07-22 21:59:30 145 tests passed. 0 tests skipped. 1452.22 s elapsed (ForkPoolWorker-3). 2024-07-22 22:00:48 00097_long_storage_buffer_race_condition: [ OK ] 141.93 sec. 2024-07-22 22:00:48 2024-07-22 22:00:48 118 tests passed. 3 tests skipped. 1530.48 s elapsed (ForkPoolWorker-2). 2024-07-22 22:00:49 00626_replace_partition_from_table_zookeeper: [ OK ] 333.93 sec. 2024-07-22 22:00:49 2024-07-22 22:00:49 Having 1 errors! 102 tests passed. 1 tests skipped. 1531.22 s elapsed (ForkPoolWorker-4). 2024-07-22 22:00:49 2024-07-22 22:00:49 Running 117 stateless tests (MainProcess). 2024-07-22 22:00:49 2024-07-22 22:00:52 03171_hashed_dictionary_short_circuit_bug_fix: [ OK ] 3.61 sec. 2024-07-22 22:00:54 03000_traverse_shadow_system_data_paths: [ OK ] 1.41 sec. 2024-07-22 22:00:58 02989_system_tables_metadata_version: [ OK ] 4.06 sec. 2024-07-22 22:01:14 02980_dist_insert_readonly_replica: [ OK ] 15.99 sec. 2024-07-22 22:02:06 02933_change_cache_setting_without_restart: [ OK ] 52.41 sec. 2024-07-22 22:02:20 02918_fuzzjson_table_function: [ OK ] 13.31 sec. 2024-07-22 22:02:23 02908_empty_named_collection: [ OK ] 3.16 sec. 2024-07-22 22:03:03 02888_replicated_merge_tree_creation: [ OK ] 39.71 sec. 2024-07-22 22:03:05 02867_create_user_ssh: [ OK ] 2.62 sec. 2024-07-22 22:03:11 02843_insertion_table_schema_infer: [ OK ] 5.33 sec. 2024-07-22 22:03:16 02842_truncate_database: [ OK ] 4.83 sec. 2024-07-22 22:03:30 02789_table_functions_errors: [ OK ] 13.97 sec. 2024-07-22 22:03:33 02775_show_columns_called_from_clickhouse: [ OK ] 3.82 sec. 2024-07-22 22:03:38 02726_async_insert_flush_queue: [ OK ] 4.56 sec. 2024-07-22 22:03:44 02703_row_policies_for_database_combination: [ OK ] 5.41 sec. 2024-07-22 22:03:51 02686_postgres_protocol_decimal_256: [ OK ] 7.16 sec. 2024-07-22 22:04:15 02566_ipv4_ipv6_binary_formats: [ OK ] 23.95 sec. 2024-07-22 22:04:19 02561_temporary_table_sessions: [ OK ] 4.37 sec. 2024-07-22 22:04:54 02504_regexp_dictionary_yaml_source: [ OK ] 35.25 sec. 2024-07-22 22:05:18 02503_insert_storage_snapshot: [ OK ] 23.67 sec. 2024-07-22 22:05:23 02496_storage_s3_profile_events: [ OK ] 4.65 sec. 2024-07-22 22:05:28 02495_s3_filter_by_file: [ OK ] 4.75 sec. 2024-07-22 22:08:05 02494_query_cache_user_isolation: [ OK ] 156.92 sec. 2024-07-22 22:08:09 02494_query_cache_bugs: [ OK ] 4.05 sec. 2024-07-22 22:08:13 02494_query_cache_compression: [ OK ] 3.77 sec. 2024-07-22 22:08:16 02494_query_cache_explain: [ OK ] 3.63 sec. 2024-07-22 22:08:20 02494_query_cache_min_query_duration: [ OK ] 3.51 sec. 2024-07-22 22:08:23 02494_query_cache_exception_handling: [ OK ] 3.45 sec. 2024-07-22 22:08:45 02482_capnp_list_of_structs: [ OK ] 21.22 sec. 2024-07-22 22:10:08 02481_async_insert_dedup: [ OK ] 83.71 sec. 2024-07-22 22:12:41 02455_one_row_from_csv_memory_usage: [ OK ] 152.35 sec. 2024-07-22 22:12:54 02422_allow_implicit_no_password: [ OK ] 13.30 sec. 2024-07-22 22:13:25 02421_record_errors_row_by_input_format: [ OK ] 31.24 sec. 2024-07-22 22:13:29 02417_json_object_each_row_format: [ OK ] 3.58 sec. 2024-07-22 22:13:33 02411_merge_tree_zero_max_read_buffer_size: [ OK ] 3.59 sec. 2024-07-22 22:13:33 02397_system_parts_race_condition_drop_rm: [ SKIPPED ] 0.00 sec. - disabled 2024-07-22 22:13:33 02396_system_parts_race_condition_rm: [ SKIPPED ] 0.00 sec. - disabled 2024-07-22 22:13:58 02377_quota_key: [ OK ] 25.28 sec. 2024-07-22 22:14:06 02364_window_view_segfault: [ OK ] 8.33 sec. 2024-07-22 22:14:10 02323_null_modifier_in_table_function: [ OK ] 3.56 sec. 2024-07-22 22:14:16 02311_system_zookeeper_insert_priv: [ OK ] 6.33 sec. 2024-07-22 22:14:19 02294_fp_seconds_profile: [ OK ] 2.55 sec. 2024-07-22 22:14:26 02293_test_zstd_window_log_max: [ OK ] 7.35 sec. 2024-07-22 22:14:53 02270_stdin_with_query_or_infile_data: [ OK ] 26.43 sec. 2024-07-22 22:16:48 02265_test_dns_profile_events: [ OK ] 115.16 sec. 2024-07-22 22:16:52 02265_rename_join_ordinary_to_atomic: [ OK ] 3.70 sec. 2024-07-22 22:17:05 02263_lazy_mark_load: [ OK ] 13.52 sec. 2024-07-22 22:17:37 02247_names_order_in_json_and_tskv: [ OK ] 31.37 sec. 2024-07-22 22:17:40 02244_column_names_in_shcmea_inference: [ OK ] 3.55 sec. 2024-07-22 22:18:59 02241_filesystem_cache_on_write_operations: [ OK ] 78.65 sec. 2024-07-22 22:19:01 02240_filesystem_query_cache: [ OK ] 1.25 sec. 2024-07-22 22:19:04 02168_avro_bug: [ OK ] 3.50 sec. 2024-07-22 22:20:23 02149_external_schema_inference: [ OK ] 78.67 sec. 2024-07-22 22:21:16 02103_tsv_csv_custom_null_representation: [ OK ] 53.42 sec. 2024-07-22 22:22:13 02103_with_names_and_types_parallel_parsing: [ OK ] 56.09 sec. 2024-07-22 22:22:16 02103_sql_user_defined_functions_composition: [ OK ] 3.47 sec. 2024-07-22 22:22:20 02098_sql_user_defined_functions_aliases: [ OK ] 3.43 sec. 2024-07-22 22:26:21 02030_capnp_format: [ OK ] 241.45 sec. 2024-07-22 22:26:45 01945_system_warnings: [ OK ] 24.10 sec. 2024-07-22 22:26:49 01915_create_or_replace_dictionary: [ OK ] 3.98 sec. 2024-07-22 22:27:46 01889_check_row_policy_defined_using_user_function: [ OK ] 56.76 sec. 2024-07-22 22:27:49 01821_table_comment: [ OK ] 2.88 sec. 2024-07-22 22:27:54 01785_dictionary_element_count: [ OK ] 5.15 sec. 2024-07-22 22:27:59 01766_hashed_dictionary_complex_key: [ OK ] 5.29 sec. 2024-07-22 22:28:06 01765_hashed_dictionary_simple_key: [ OK ] 7.01 sec. 2024-07-22 22:28:11 01760_system_dictionaries: [ OK ] 4.95 sec. 2024-07-22 22:28:15 01759_dictionary_unique_attribute_names: [ OK ] 3.80 sec. 2024-07-22 22:28:22 01753_direct_dictionary_simple_key: [ OK ] 6.49 sec. 2024-07-22 22:28:26 01747_executable_pool_dictionary_implicit_key: [ OK ] 3.63 sec. 2024-07-22 22:28:26 01747_system_session_log_long: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 22:28:29 01746_executable_pool_dictionary: [ OK ] 3.60 sec. 2024-07-22 22:28:43 01656_test_query_log_factories_info: [ OK ] 13.78 sec. 2024-07-22 22:28:47 01625_constraints_index_append: [ OK ] 4.06 sec. 2024-07-22 22:28:50 01602_show_create_view: [ OK ] 3.25 sec. 2024-07-22 22:29:48 01600_log_queries_with_extensive_info: [ OK ] 57.73 sec. 2024-07-22 22:30:13 01545_system_errors: [ OK ] 24.42 sec. 2024-07-22 22:30:40 01543_avro_deserialization_with_lc: [ OK ] 27.68 sec. 2024-07-22 22:30:49 01524_do_not_merge_across_partitions_select_final: [ OK ] 8.77 sec. 2024-07-22 22:30:54 01516_create_table_primary_key: [ OK ] 4.39 sec. 2024-07-22 22:31:09 01507_clickhouse_server_start_with_embedded_config: [ OK ] 15.80 sec. 2024-07-22 22:31:13 01494_storage_join_persistency: [ OK ] 4.01 sec. 2024-07-22 22:31:18 01493_storage_set_persistency: [ OK ] 4.04 sec. 2024-07-22 22:31:26 01474_executable_dictionary: [ OK ] 8.38 sec. 2024-07-22 22:31:30 01471_calculate_ttl_during_merge: [ OK ] 4.22 sec. 2024-07-22 22:31:34 01455_rank_correlation_spearman: [ OK ] 4.04 sec. 2024-07-22 22:31:34 01396_inactive_replica_cleanup_nodes_zookeeper: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 22:31:38 01383_remote_ambiguous_column_shard: [ OK ] 4.03 sec. 2024-07-22 22:31:43 01355_ilike: [ OK ] 4.48 sec. 2024-07-22 22:32:40 01318_long_unsuccessful_mutation_zookeeper: [ OK ] 57.00 sec. 2024-07-22 22:32:44 01293_system_distribution_queue: [ OK ] 3.96 sec. 2024-07-22 22:33:10 01280_ssd_complex_key_dictionary: [ OK ] 26.39 sec. 2024-07-22 22:33:44 01275_parallel_mv: [ OK ] 33.93 sec. 2024-07-22 22:33:49 01257_dictionary_mismatch_types: [ OK ] 4.51 sec. 2024-07-22 22:33:53 01254_dict_create_without_db: [ OK ] 3.90 sec. 2024-07-22 22:33:58 01251_dict_is_in_infinite_loop: [ OK ] 5.03 sec. 2024-07-22 22:34:01 01249_bad_arguments_for_bloom_filter: [ OK ] 3.19 sec. 2024-07-22 22:34:07 01232_extremes: [ OK ] 5.39 sec. 2024-07-22 22:34:07 01200_mutations_memory_consumption: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 22:35:35 01161_all_system_tables: [ OK ] 88.46 sec. 2024-07-22 22:35:41 01155_rename_move_materialized_view: [ OK ] 5.90 sec. 2024-07-22 22:35:44 01110_dictionary_layout_without_arguments: [ OK ] 2.56 sec. 2024-07-22 22:35:49 01103_distributed_product_mode_local_column_renames: [ OK ] 5.14 sec. 2024-07-22 22:40:18 01079_parallel_alter_modify_zookeeper_long: [ OK ] 269.42 sec. 2024-07-22 22:43:47 01079_parallel_alter_add_drop_column_zookeeper: [ OK ] 208.58 sec. 2024-07-22 22:43:51 01078_window_view_alter_query_watch: [ OK ] 3.90 sec. 2024-07-22 22:44:04 01072_window_view_multiple_columns_groupby: [ OK ] 12.53 sec. 2024-07-22 22:44:06 01065_window_view_event_hop_watch_bounded: [ OK ] 2.77 sec. 2024-07-22 22:44:09 01062_window_view_event_hop_watch_asc: [ OK ] 3.08 sec. 2024-07-22 22:44:21 01053_ssd_dictionary: [ OK ] 11.48 sec. 2024-07-22 22:45:04 01042_system_reload_dictionary_reloads_completely: [ OK ] 43.30 sec. 2024-07-22 22:45:09 01036_no_superfluous_dict_reload_on_create_database_2: [ OK ] 4.15 sec. 2024-07-22 22:45:14 01018_dictionaries_from_dictionaries: [ OK ] 4.98 sec. 2024-07-22 22:45:28 01003_kill_query_race_condition: [ OK ] 13.97 sec. 2024-07-22 22:45:32 00985_merge_stack_overflow: [ OK ] 4.81 sec. 2024-07-22 22:45:40 00950_dict_get: [ OK ] 7.57 sec. 2024-07-22 22:46:07 00933_test_fix_extra_seek_on_compressed_cache: [ OK ] 27.17 sec. 2024-07-22 22:46:13 00510_materizlized_view_and_deduplication_zookeeper: [ OK ] 5.56 sec. 2024-07-22 22:46:13 2024-07-22 22:46:13 112 tests passed. 5 tests skipped. 2724.32 s elapsed (MainProcess). 2024-07-22 22:46:17 Won't run stateful tests because test data wasn't loaded. 2024-07-22 22:46:17 Checking the hung queries: done 2024-07-22 22:46:17 2024-07-22 22:46:17 No queries hung. 2024-07-22 22:46:17 All tests have finished. 2024-07-22 22:46:17 2024-07-22 22:46:17 Top patterns of log messages: 2024-07-22 22:46:17 2024-07-22 22:46:17 count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string 2024-07-22 22:46:17 2024-07-22 22:46:17 1. 34710 0.056 1.95 MiB 0.011 11 476 ['Trace'] 0.002 Access granted: {}{} 2024-07-22 22:46:17 2. 31021 0.05 8.18 MiB 0.044 1 142 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 2024-07-22 22:46:17 3. 31007 0.05 4.64 MiB 0.025 4 141 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 2024-07-22 22:46:17 4. 24893 0.04 702.26 KiB 0.004 1 133 ['Debug'] 0 Processed in {} sec. 2024-07-22 22:46:17 5. 21063 0.034 57.11 MiB 0.308 1 282 ['Trace'] 0.005 Query {} to stage {}{} 2024-07-22 22:46:17 6. 20890 0.034 57.52 MiB 0.31 1 282 ['Trace'] 0.005 Query {} from stage {} to stage {}{} 2024-07-22 22:46:17 7. 16509 0.027 1.28 MiB 0.007 1 131 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 2024-07-22 22:46:17 8. 15798 0.026 1.10 MiB 0.006 1 1469 ['Trace'] 0.593 Reserved {} on local disk {}, having unreserved {}. 2024-07-22 22:46:17 9. 15550 0.025 546.71 KiB 0.003 1 12 ['Trace'] 1 Keeper request. Address: {} 2024-07-22 22:46:17 10. 15327 0.025 686.22 KiB 0.004 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 2024-07-22 22:46:17 11. 15107 0.025 1.32 MiB 0.007 1 1020 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 2024-07-22 22:46:17 12. 14382 0.023 449.44 KiB 0.002 1 11 ['Debug'] 1 Receive four letter command {} 2024-07-22 22:46:17 13. 12862 0.021 1.50 MiB 0.008 652 603 ['Trace'] 0.479 Renaming temporary part {} to {} with tid {}. 2024-07-22 22:46:17 14. 12557 0.02 870.81 KiB 0.005 653 1093 ['Trace'] 0.695 Trying to reserve {} using storage policy from min volume index {} 2024-07-22 22:46:17 15. 12549 0.02 606.00 KiB 0.003 1 589 ['Trace'] 0.45 filled checksums {} 2024-07-22 22:46:17 16. 11752 0.019 586.76 KiB 0.003 1 150 ['Debug'] 0.27 Peak memory usage{}: {}. 2024-07-22 22:46:17 17. 10917 0.018 321.45 KiB 0.002 1 1019 ['Trace'] 0 Aggregation method: {} 2024-07-22 22:46:17 18. 10489 0.017 861.62 KiB 0.005 6 235 ['Debug'] 0.99 {} Authenticating user '{}' from {} 2024-07-22 22:46:17 19. 10336 0.017 1.13 MiB 0.006 6 235 ['Debug'] 0.99 {} Authenticated with global context as user {} 2024-07-22 22:46:17 20. 10309 0.017 975.85 KiB 0.005 1 48 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 2024-07-22 22:46:17 21. 10308 0.017 905.98 KiB 0.005 6 229 ['Debug'] 0.99 {} Logout, user_id: {} 2024-07-22 22:46:17 22. 10219 0.017 1.09 MiB 0.006 4 141 ['Debug'] 1 {} Creating session context with user_id: {} 2024-07-22 22:46:17 23. 6761 0.011 72.63 KiB 0 1 1010 ['Trace'] 0 Aggregating 2024-07-22 22:46:17 24. 6740 0.011 876.85 KiB 0.005 1 2 ['Trace'] 1 Creating part at path {} 2024-07-22 22:46:17 25. 6615 0.011 1.18 MiB 0.006 2 89 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 2024-07-22 22:46:17 26. 6605 0.011 3.43 MiB 0.019 2 89 ['Trace'] 1 Request URI: {} 2024-07-22 22:46:17 27. 6394 0.01 131.13 KiB 0.001 2 89 ['Debug'] 0.079 Done processing query 2024-07-22 22:46:17 28. 5606 0.009 203.97 KiB 0.001 16 16 ['Trace'] 1 Flushed system log up to offset {} 2024-07-22 22:46:17 29. 5606 0.009 327.17 KiB 0.002 16 16 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 2024-07-22 22:46:17 30. 5575 0.009 453.95 KiB 0.002 1 994 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 2024-07-22 22:46:17 31. 4311 0.007 145.10 KiB 0.001 2 140 ['Trace'] 1 TCP Request. Address: {} 2024-07-22 22:46:17 32. 4311 0.007 406.85 KiB 0.002 1 140 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 2024-07-22 22:46:17 33. 4270 0.007 112.59 KiB 0.001 1 131 ['Debug'] 1 Done processing connection. 2024-07-22 22:46:17 34. 3910 0.006 492.15 KiB 0.003 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 2024-07-22 22:46:17 35. 3521 0.006 278.84 KiB 0.001 474 105 ['Trace'] 0.003 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 2024-07-22 22:46:17 36. 3278 0.005 73.63 KiB 0 1 981 ['Trace'] 0 Merging aggregated data 2024-07-22 22:46:17 37. 3145 0.005 170.96 KiB 0.001 157 545 ['Debug'] 0.931 Selected {} parts from {} to {} 2024-07-22 22:46:17 38. 3079 0.005 237.54 KiB 0.001 1 93 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 2024-07-22 22:46:17 39. 2836 0.005 230.09 KiB 0.001 89 994 ['Trace'] 0.9 Part {} is not stored on zero-copy replicated disk, blobs can be removed 2024-07-22 22:46:17 40. 2774 0.005 307.20 KiB 0.002 1 27 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 2024-07-22 22:46:17 41. 2762 0.004 94.33 KiB 0 1 50 ['Debug'] 0 Selected MergeAlgorithm: {} 2024-07-22 22:46:17 42. 2762 0.004 231.15 KiB 0.001 1 50 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 2024-07-22 22:46:17 43. 2757 0.004 360.96 KiB 0.002 1 50 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 2024-07-22 22:46:17 44. 2754 0.004 184.62 KiB 0.001 161 50 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 2024-07-22 22:46:17 45. 2741 0.004 355.93 KiB 0.002 1 51 ['Debug'] 0.001 Before join block: '{}' 2024-07-22 22:46:17 46. 2741 0.004 496.40 KiB 0.003 1 51 ['Debug'] 0.001 After join block: '{}' 2024-07-22 22:46:17 47. 2696 0.004 534.35 KiB 0.003 1 510 ['Information'] 1 Removing metadata {} of dropped table {} 2024-07-22 22:46:17 48. 2696 0.004 342.37 KiB 0.002 1 510 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 2024-07-22 22:46:17 49. 2683 0.004 199.13 KiB 0.001 1 66 ['Debug'] 0 Waiting for table {} to be finally dropped 2024-07-22 22:46:17 50. 2671 0.004 242.77 KiB 0.001 81 509 ['Trace'] 0.998 Insert entry {} to queue with type {} 2024-07-22 22:46:17 51. 2640 0.004 366.05 KiB 0.002 84 504 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 2024-07-22 22:46:17 52. 2573 0.004 70.28 KiB 0 553 159 ['Debug'] 0.031 Key condition: {} 2024-07-22 22:46:17 53. 2535 0.004 123.54 KiB 0.001 109 508 ['Trace'] 1 Scheduling next merge selecting task after {}ms 2024-07-22 22:46:17 54. 2516 0.004 22.11 KiB 0 2 74 ['Trace'] 0.002 No tables 2024-07-22 22:46:17 55. 2514 0.004 144.85 KiB 0.001 80 508 ['Debug'] 0.999 Pulling {} entries to queue: {} - {} 2024-07-22 22:46:17 56. 2514 0.004 63.83 KiB 0 80 508 ['Debug'] 0.999 Pulled {} entries to queue. 2024-07-22 22:46:17 57. 2508 0.004 51.44 KiB 0 1 905 ['Debug'] 1 Stop worker in {} 2024-07-22 22:46:17 58. 2508 0.004 174.04 KiB 0.001 1 683 ['Debug'] 1 Finish load job '{}' with status {} 2024-07-22 22:46:17 59. 2508 0.004 78.38 KiB 0 1 756 ['Debug'] 0.499 Spawn loader worker #{} in {} 2024-07-22 22:46:17 60. 2508 0.004 171.60 KiB 0.001 1 74 ['Debug'] 0.002 Schedule load job '{}' into {} 2024-07-22 22:46:17 61. 2508 0.004 164.25 KiB 0.001 1 683 ['Debug'] 1 Execute load job '{}' in {} 2024-07-22 22:46:17 62. 2507 0.004 198.48 KiB 0.001 1 74 ['Debug'] 0.002 Prioritize load job '{}': {} -> {} 2024-07-22 22:46:17 63. 2498 0.004 82.94 KiB 0 1 752 ['Debug'] 0.501 Change current priority: {} -> {} 2024-07-22 22:46:17 64. 2442 0.004 365.93 KiB 0.002 1 652 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 2024-07-22 22:46:17 65. 2442 0.004 276.63 KiB 0.001 1 667 ['Information'] 0 Sorting and writing part of data into temporary file {} 2024-07-22 22:46:17 66. 2442 0.004 280.59 KiB 0.001 638 382 ['Debug'] 0.984 Removing {} parts from filesystem (serially): Parts: [{}] 2024-07-22 22:46:17 67. 2407 0.004 275.40 KiB 0.001 548 159 ['Debug'] 0.034 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 2024-07-22 22:46:17 68. 2265 0.004 235.19 KiB 0.001 1 71 ['Trace'] 0.038 PREWHERE condition was split into {} steps: {} 2024-07-22 22:46:17 69. 2065 0.003 106.88 KiB 0.001 485 159 ['Trace'] 0.038 Spreading mark ranges among streams (default reading) 2024-07-22 22:46:17 70. 1881 0.003 170.04 KiB 0.001 1 799 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 2024-07-22 22:46:17 71. 1827 0.003 145.59 KiB 0.001 1 851 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 2024-07-22 22:46:17 72. 1817 0.003 181.99 KiB 0.001 43 76 ['Debug'] 0.986 Removing {} parts from memory: Parts: [{}] 2024-07-22 22:46:17 73. 1815 0.003 180.12 KiB 0.001 41 74 ['Trace'] 0.987 Found {} old parts to remove. Parts: [{}] 2024-07-22 22:46:17 74. 1703 0.003 49.89 KiB 0 109 500 ['Debug'] 0.995 Updating strategy picker state 2024-07-22 22:46:17 75. 1478 0.002 4.84 MiB 0.026 2 1 ['Error'] 0 Table {}.{} does not exist. Maybe you meant {}.{}? 2024-07-22 22:46:17 76. 1317 0.002 52.63 KiB 0 68 33 ['Debug'] 0.38 Committing part {} to zookeeper 2024-07-22 22:46:17 77. 1263 0.002 108.83 KiB 0.001 14 82 ['Trace'] 0.954 List of all grants including implicit: {} 2024-07-22 22:46:17 78. 1263 0.002 68.23 KiB 0 14 82 ['Trace'] 0.954 List of all grants: {} 2024-07-22 22:46:17 79. 1263 0.002 96.21 KiB 0.001 14 82 ['Trace'] 0.954 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} 2024-07-22 22:46:17 80. 1258 0.002 74.82 KiB 0 1 74 ['Information'] 0.002 Parsed metadata of {} tables in {} databases in {} sec 2024-07-22 22:46:17 81. 1258 0.002 103.28 KiB 0.001 1253 74 ['Information'] 0.002 Metadata processed, database {} has {} tables and {} dictionaries in total. 2024-07-22 22:46:17 82. 1218 0.002 47.40 KiB 0 67 32 ['Debug'] 0.41 Part {} committed to zookeeper 2024-07-22 22:46:17 83. 1212 0.002 74.67 KiB 0 1 74 ['Debug'] 0.002 Wait load job '{}' in {} 2024-07-22 22:46:17 84. 1175 0.002 213.89 KiB 0.001 1 53 ['Trace'] 0.002 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {} 2024-07-22 22:46:17 85. 1166 0.002 40.99 KiB 0 1 11 ['Warning'] 1 Not enabled four letter command {} 2024-07-22 22:46:17 86. 1159 0.002 74.83 KiB 0 1 70 ['Trace'] 0.017 {}Join data is being destroyed, {} bytes and {} rows in hash table 2024-07-22 22:46:17 87. 1134 0.002 82.64 KiB 0 1 95 ['Trace'] 0.035 The min valid primary key position for moving to the tail of PREWHERE is {} 2024-07-22 22:46:17 88. 1100 0.002 46.20 KiB 0 1 665 ['Information'] 0 There are {} temporary sorted parts to merge 2024-07-22 22:46:17 89. 1075 0.002 18.90 KiB 0 1016 89 ['Debug'] 0.023 Loading data parts 2024-07-22 22:46:17 90. 1049 0.002 23.56 KiB 0 1016 86 ['Debug'] 0.021 There are no data parts 2024-07-22 22:46:17 91. 1032 0.002 72.62 KiB 0 6 25 ['Debug'] 0.006 Flushing buffer with {} rows, {} bytes, age {} seconds, took {} ms {}. 2024-07-22 22:46:17 92. 1013 0.002 65.29 KiB 0 991 438 ['Information'] 0.964 dropAllData: removing table directory recursive to cleanup garbage 2024-07-22 22:46:17 93. 1013 0.002 30.67 KiB 0 991 438 ['Trace'] 0.964 dropAllData: waiting for locks. 2024-07-22 22:46:17 94. 1013 0.002 48.47 KiB 0 991 438 ['Trace'] 0.964 dropAllData: removing all data parts from memory. 2024-07-22 22:46:17 95. 1013 0.002 76.17 KiB 0 991 438 ['Information'] 0.964 dropAllData: remove format_version.txt, detached, moving and write ahead logs 2024-07-22 22:46:17 96. 1013 0.002 58.46 KiB 0 991 438 ['Trace'] 0.964 dropAllData: removing data parts (count {}) from filesystem. 2024-07-22 22:46:17 97. 1013 0.002 42.54 KiB 0 991 438 ['Information'] 0.964 dropAllData: clearing temporary directories 2024-07-22 22:46:17 98. 1013 0.002 17.81 KiB 0 991 438 ['Trace'] 0.964 dropAllData: done. 2024-07-22 22:46:17 99. 998 0.002 133.28 KiB 0.001 1 3 ['Trace'] 0 async insert part, part id {}, block id {}, offsets {}, size {} 2024-07-22 22:46:18 100. 993 0.002 31.38 KiB 0 19 20 ['Debug'] 0 Requested flush up to offset {} 2024-07-22 22:46:18 2024-07-22 22:46:18 2024-07-22 22:46:18 2024-07-22 22:46:18 Top messages without format string (fmt::runtime): 2024-07-22 22:46:18 2024-07-22 22:46:18 count pattern runtime_message line 2024-07-22 22:46:18 2024-07-22 22:46:18 1. 16 CodeDBExceptionReceivedfromDBExc Code: 47. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Identifier '__table1.arr.size0' cannot be resolved from table with name __table1. In scope SELECT __table1.`arr.size0` AS `arr.size0`, __table1.`n.null` AS `n.null`, __table1.`t.s1` AS ` ('/executeQuery.cpp',218) 2024-07-22 22:46:18 2. 7 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below): 2024-07-22 22:46:18 2024-07-22 22:46:18 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000 ('/Exception.cpp',222) 2024-07-22 22:46:18 3. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 ('$'): $$ab 2024-07-22 22:46:18 . Expected one of: ALL, DISTINCT ON, DISTINCT, TOP, not empty list of expressions, list of expressions, list of elements, expression with optional alias, element of expression with opt ('/executeQuery.cpp',218) 2024-07-22 22:46:18 4. 6 CodeDBExceptionReceivedfromlocal Code: 242. DB::Exception: Received from localhost:9000. DB::Exception: Table is in readonly mode: replica_path=/tables/shard_1/data/replicas/read. Stack trace: 2024-07-22 22:46:18 2024-07-22 22:46:18 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x0000 ('/executeQuery.cpp',218) 2024-07-22 22:46:18 5. 4 CodeDBExceptionFailedtogetobject Code: 499. DB::Exception: Failed to get object info: No response body.. HTTP response code: 404: While executing S3. (S3_ERROR) (version 24.3.5.47.altinitystable (altinity build)) (from [::1]:58278) (comment: 02752_forbidden_headers.sql) (in query: SELECT ('/executeQuery.cpp',218) 2024-07-22 22:46:18 6. 4 CodeDBExceptionSQLitedatabasefil Code: 481. DB::Exception: SQLite database file path '/etc/passwd' must be inside 'user_files' directory. (PATH_ACCESS_DENIED) (version 24.3.5.47.altinitystable (altinity build)) (from [::1]:60696) (comment: 02918_sqlite_path_check.sh) (in query: Select * f ('/executeQuery.cpp',218) 2024-07-22 22:46:18 7. 3 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71) 2024-07-22 22:46:18 8. 2 CodeDBExceptionNumberequalswhile Code: 395. DB::Exception: Number equals 1000: while executing 'FUNCTION throwIf(equals(__table1.number, 1000_UInt16) :: 0, 'Number equals 1000'_String :: 2) -> throwIf(equals(__table1.number, 1000_UInt16), 'Number equals 1000'_String) UInt8 : 1'. (FUNCTION ('/executeQuery.cpp',218) 2024-07-22 22:46:18 9. 1 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 10. 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 11. 1 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 12. 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 13. 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 14. 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 15. 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 16. 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 17. 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === 2024-07-22 22:46:18 commit index 0 2024-07-22 22:46:18 term 0 2024-07-22 22:46:18 election timer allowed 2024-07-22 22:46:18 log store start 1, end 0 2024-07-22 22:46:18 config log idx 0, prev log idx 0 2024-07-22 22:46:18 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 18. 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 2024-07-22 22:46:18 my id: 1, voting_member 2024-07-22 22:46:18 num peers: 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 19. 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 20. 1 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 21. 1 PocoExceptionCodeecodeNotfoundbo Poco::Exception. Code: 1000, e.code() = 0, Not found: boundary, Stack trace (when copying this message, always include the lines below): 2024-07-22 22:46:18 2024-07-22 22:46:18 0. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000000a8ef122 2024-07-22 22:46:18 1. /build/ ('/Exception.cpp',222) 2024-07-22 22:46:18 22. 1 Requestfailednowwaitingmsbeforea Request failed, now waiting 0 ms before attempting again. ('/AWSLogger.cpp',71) 2024-07-22 22:46:18 23. 1 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 2024-07-22 22:46:18 peer 1, DC ID 0, localhost:9234, voting member, 1 2024-07-22 22:46:18 my id: 1, leader: 1, term: 1 ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 24. 1 Failedtomakerequesttohttplocalho Failed to make request to: http://localhost:8123/123/4: Poco::Exception. Code: 1000, e.code() = 0, Syntax error: Not a valid integer: 'is', Stack trace (when copying this message, always include the lines below): 2024-07-22 22:46:18 2024-07-22 22:46:18 0. /build/contrib/llvm-project/libcxx/incl ('/PocoHTTPClient.cpp',576) 2024-07-22 22:46:18 25. 1 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 26. 1 parameterselectiontimeoutrangehe parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 100000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwardin ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 27. 1 startingup starting up ('',0) 2024-07-22 22:46:18 28. 1 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43) 2024-07-22 22:46:18 29. 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 2024-07-22 22:48:58 30. 1 Forkedachildprocesstowatch Forked a child process to watch ('',0) 2024-07-22 22:48:58 2024-07-22 22:48:58 2024-07-22 22:48:58 Failed to get stats about log messages: timed out + set -e + [[ 0 -eq 124 ]] + return 0 Files in current directory + echo 'Files in current directory' + ls -la ./ total 137524 drwxr-xr-x 1 root root 4096 Jul 22 22:30 . drwxr-xr-x 1 root root 4096 Jul 22 22:30 .. -rw-rw-r-- 1 1000 1000 300 Jul 22 21:29 analyzer_tech_debt.txt -rw-rw-r-- 1 root root 1566 Jun 13 06:03 attach_gdb.lib -rw-r--r-- 1 root root 1481 Jul 22 21:33 __azurite_db_blob_extent__.json -rw-r--r-- 1 root root 4237 Jul 22 21:33 __azurite_db_blob__.json -rw-r--r-- 1 root root 61881 Jul 22 22:47 azurite_log lrwxrwxrwx 1 root root 7 Apr 27 05:02 bin -> usr/bin drwxr-xr-x 2 root root 4096 Jul 22 21:33 __blobstorage__ drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-x--- 4 root root 4096 Jul 22 22:12 data drwxr-xr-x 5 root root 340 Jul 22 21:32 dev drwxr-x--- 2 root root 4096 Jul 22 22:12 dictionaries_lib -rwxr-xr-x 1 root root 0 Jul 22 21:32 .dockerenv drwxr-xr-x 1 root root 4096 Jul 22 21:32 etc drwxr-x--- 2 root root 4096 Jul 22 22:12 flags drwxr-x--- 2 root root 4096 Jul 22 22:12 format_schemas drwxr-xr-x 1 1000 1000 4096 Jul 22 21:33 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Apr 27 05:02 lib -> usr/lib lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Apr 27 05:02 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jun 13 06:04 mc drwxr-xr-x 2 root root 4096 Apr 27 05:02 media drwxr-x--- 2 root root 4096 Jul 22 22:12 metadata drwxr-x--- 2 root root 4096 Jul 22 22:12 metadata_dropped -rwxr-xr-x 1 root root 118595584 Jun 13 06:04 minio drwxr-xr-x 4 root root 4096 Jul 22 21:33 minio_data drwxr-xr-x 2 root root 4096 Apr 27 05:02 mnt drwxr-x--- 2 root root 4096 Jul 22 22:12 named_collections drwxr-xr-x 2 root root 4096 Apr 27 05:02 opt -rw-r--r-- 1 root root 0 Feb 15 01:09 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Jul 22 21:32 package_folder drwxr-x--- 2 root root 4096 Jul 22 22:30 preprocessed_configs dr-xr-xr-x 311 root root 0 Jul 22 21:32 proc -rwxrwxr-x 1 root root 7989 May 14 20:27 process_functional_tests_result.py -rw-r----- 1 root root 1 Jul 22 22:12 quotas.list -rw-r----- 1 root root 1 Jul 22 22:12 roles.list drwx------ 1 root root 4096 Jul 22 22:44 root -rw-r----- 1 root root 1 Jul 22 22:12 row_policies.list drwxr-xr-x 1 root root 4096 Jul 22 21:32 run -rwxrwxr-x 1 root root 16095 Jun 13 06:03 run.sh lrwxrwxrwx 1 root root 8 Apr 27 05:02 sbin -> usr/sbin -rw-r--r-- 1 root root 462 Jul 22 21:33 script.gdb -rw-r--r-- 1 root root 41826 Jul 22 22:31 server.log -rw-r----- 1 root root 1 Jul 22 22:12 settings_profiles.list -rwxrwxr-x 1 root root 10462 May 14 20:27 setup_export_logs.sh -rwxrwxr-x 1 root root 351 Jun 13 06:03 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3464 Jun 13 06:03 setup_minio.sh drwxr-xr-x 2 root root 4096 Apr 27 05:02 srv drwxr-x--- 4 root root 4096 Jul 22 22:12 store -rw-rw-r-- 1 root root 13192 Jun 13 06:03 stress_tests.lib dr-xr-xr-x 13 root root 0 Jul 22 21:32 sys drwxrwxr-x 2 1000 1000 4096 Jul 22 21:35 test_output drwxrwxrwt 1 root root 20480 Jul 22 22:48 tmp drwxr-xr-x 2 root root 4096 Jul 22 21:35 user_defined drwxr-x--- 2 root root 4096 Jul 22 22:12 user_files drwxr-x--- 2 root root 4096 Jul 22 22:12 user_scripts -rw-r----- 1 root root 1 Jul 22 22:12 users.list drwxr-xr-x 1 root root 4096 Apr 27 05:02 usr -rw-rw-r-- 1 root root 833 Jun 13 06:03 utils.lib -rw-r----- 1 root root 36 Jul 22 22:12 uuid drwxr-xr-x 1 root root 4096 Apr 27 05:05 var Files in root directory + echo 'Files in root directory' + ls -la / total 137524 drwxr-xr-x 1 root root 4096 Jul 22 22:30 . drwxr-xr-x 1 root root 4096 Jul 22 22:30 .. -rw-rw-r-- 1 1000 1000 300 Jul 22 21:29 analyzer_tech_debt.txt -rw-rw-r-- 1 root root 1566 Jun 13 06:03 attach_gdb.lib -rw-r--r-- 1 root root 1481 Jul 22 21:33 __azurite_db_blob_extent__.json -rw-r--r-- 1 root root 4237 Jul 22 21:33 __azurite_db_blob__.json -rw-r--r-- 1 root root 61881 Jul 22 22:47 azurite_log lrwxrwxrwx 1 root root 7 Apr 27 05:02 bin -> usr/bin drwxr-xr-x 2 root root 4096 Jul 22 21:33 __blobstorage__ drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-x--- 4 root root 4096 Jul 22 22:12 data drwxr-xr-x 5 root root 340 Jul 22 21:32 dev drwxr-x--- 2 root root 4096 Jul 22 22:12 dictionaries_lib -rwxr-xr-x 1 root root 0 Jul 22 21:32 .dockerenv drwxr-xr-x 1 root root 4096 Jul 22 21:32 etc drwxr-x--- 2 root root 4096 Jul 22 22:12 flags drwxr-x--- 2 root root 4096 Jul 22 22:12 format_schemas drwxr-xr-x 1 1000 1000 4096 Jul 22 21:33 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Apr 27 05:02 lib -> usr/lib lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Apr 27 05:02 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Apr 27 05:02 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jun 13 06:04 mc drwxr-xr-x 2 root root 4096 Apr 27 05:02 media drwxr-x--- 2 root root 4096 Jul 22 22:12 metadata drwxr-x--- 2 root root 4096 Jul 22 22:12 metadata_dropped -rwxr-xr-x 1 root root 118595584 Jun 13 06:04 minio drwxr-xr-x 4 root root 4096 Jul 22 21:33 minio_data drwxr-xr-x 2 root root 4096 Apr 27 05:02 mnt drwxr-x--- 2 root root 4096 Jul 22 22:12 named_collections drwxr-xr-x 2 root root 4096 Apr 27 05:02 opt -rw-r--r-- 1 root root 0 Feb 15 01:09 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Jul 22 21:32 package_folder drwxr-x--- 2 root root 4096 Jul 22 22:30 preprocessed_configs dr-xr-xr-x 311 root root 0 Jul 22 21:32 proc -rwxrwxr-x 1 root root 7989 May 14 20:27 process_functional_tests_result.py -rw-r----- 1 root root 1 Jul 22 22:12 quotas.list -rw-r----- 1 root root 1 Jul 22 22:12 roles.list drwx------ 1 root root 4096 Jul 22 22:44 root -rw-r----- 1 root root 1 Jul 22 22:12 row_policies.list drwxr-xr-x 1 root root 4096 Jul 22 21:32 run -rwxrwxr-x 1 root root 16095 Jun 13 06:03 run.sh lrwxrwxrwx 1 root root 8 Apr 27 05:02 sbin -> usr/sbin -rw-r--r-- 1 root root 462 Jul 22 21:33 script.gdb -rw-r--r-- 1 root root 41826 Jul 22 22:31 server.log -rw-r----- 1 root root 1 Jul 22 22:12 settings_profiles.list -rwxrwxr-x 1 root root 10462 May 14 20:27 setup_export_logs.sh -rwxrwxr-x 1 root root 351 Jun 13 06:03 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3464 Jun 13 06:03 setup_minio.sh drwxr-xr-x 2 root root 4096 Apr 27 05:02 srv drwxr-x--- 4 root root 4096 Jul 22 22:12 store -rw-rw-r-- 1 root root 13192 Jun 13 06:03 stress_tests.lib dr-xr-xr-x 13 root root 0 Jul 22 21:32 sys drwxrwxr-x 2 1000 1000 4096 Jul 22 21:35 test_output drwxrwxrwt 1 root root 20480 Jul 22 22:48 tmp drwxr-xr-x 2 root root 4096 Jul 22 21:35 user_defined drwxr-x--- 2 root root 4096 Jul 22 22:12 user_files drwxr-x--- 2 root root 4096 Jul 22 22:12 user_scripts -rw-r----- 1 root root 1 Jul 22 22:12 users.list drwxr-xr-x 1 root root 4096 Apr 27 05:02 usr -rw-rw-r-- 1 root root 833 Jun 13 06:03 utils.lib -rw-r----- 1 root root 36 Jul 22 22:12 uuid drwxr-xr-x 1 root root 4096 Apr 27 05:05 var + /process_functional_tests_result.py 2024-07-22 22:48:58,391 File /analyzer_tech_debt.txt with broken tests found 2024-07-22 22:48:58,392 Broken tests in the list: 11 2024-07-22 22:48:58,392 Find files in result folder test_result.txt,garbage.log,gdb.log,run.log 2024-07-22 22:48:58,399 Is flaky check: False 2024-07-22 22:48:58,399 Result parsed 2024-07-22 22:48:58,400 Result written + clickhouse-client -q 'system flush logs' Detach all logs replication + stop_logs_replication + echo 'Detach all logs replication' + clickhouse-client --query 'select database||'\''.'\''||table from system.tables where database = '\''system'\'' and (table like '\''%_sender'\'' or table like '\''%_watcher'\'')' + tee /dev/stderr + xargs -n1 -r -i clickhouse-client --query 'drop table {}' xargs: warning: options --max-args and --replace/-I/-i are mutually exclusive, ignoring previous --max-args value + failed_to_save_logs=0 + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + err='++ clickhouse-client -q '\''select * from system.query_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + echo '++ clickhouse-client -q '\''select * from system.query_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + [[ 0 != \1\0\4 ]] + failed_to_save_logs=1 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log ++ clickhouse-client -q 'select * from system.query_log format TSVWithNamesAndTypes' ++ zstd --threads=0 ++ clickhouse-client -q 'select * from system.zookeeper_log format TSVWithNamesAndTypes' ++ zstd --threads=0 + err='++ clickhouse-client -q '\''select * from system.zookeeper_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + echo '++ clickhouse-client -q '\''select * from system.zookeeper_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + [[ 0 != \1\0\8 ]] + failed_to_save_logs=1 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + err='++ clickhouse-client -q '\''select * from system.trace_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + echo '++ clickhouse-client -q '\''select * from system.trace_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + [[ 0 != \1\0\4 ]] + failed_to_save_logs=1 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log ++ clickhouse-client -q 'select * from system.trace_log format TSVWithNamesAndTypes' ++ zstd --threads=0 ++ clickhouse-client -q 'select * from system.transactions_info_log format TSVWithNamesAndTypes' ++ zstd --threads=0 + err='++ clickhouse-client -q '\''select * from system.transactions_info_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + echo '++ clickhouse-client -q '\''select * from system.transactions_info_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + [[ 0 != \1\1\6 ]] + failed_to_save_logs=1 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log ++ clickhouse-client -q 'select * from system.metric_log format TSVWithNamesAndTypes' ++ zstd --threads=0 + err='++ clickhouse-client -q '\''select * from system.metric_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + echo '++ clickhouse-client -q '\''select * from system.metric_log format TSVWithNamesAndTypes'\'' ++ zstd --threads=0' + [[ 0 != \1\0\5 ]] + failed_to_save_logs=1 + [[ -n '' ]] + sudo clickhouse stop script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Sent terminate signal to process with pid 738. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 738. The process with pid = 738 does not exist. Server stopped + [[ -n '' ]] + rg -Fa '' /var/log/clickhouse-server/clickhouse-server.log + : + rg -A50 -Fa ============ /var/log/clickhouse-server/stderr.log + : + data_path_config=--path=/var/lib/clickhouse/ + zstd --threads=0 + [[ -n '' ]] + '[' 1 -ne 0 ']' + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables --stacktrace -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables --stacktrace -q 'select * from system.zookeeper_log format TSVWithNamesAndTypes' + zstd --threads=0 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables --stacktrace -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables --stacktrace -q 'select * from system.transactions_info_log format TSVWithNamesAndTypes' + zstd --threads=0 + [[ -n '' ]] + for table in query_log zookeeper_log trace_log transactions_info_log metric_log + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables --stacktrace -q 'select * from system.metric_log format TSVWithNamesAndTypes' + zstd --threads=0 + [[ -n '' ]] + for trace_type in CPU Memory Real + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables -q ' select arrayStringConcat((arrayMap(x -> concat(splitByChar('\''/'\'', addressToLine(x))[-1], '\''#'\'', demangle(addressToSymbol(x)) ), trace)), '\'';'\'') AS stack, count(*) AS samples from system.trace_log where trace_type = '\''CPU'\'' group by trace order by samples desc settings allow_introspection_functions = 1 format TabSeparated' + zstd --threads=0 + for trace_type in CPU Memory Real + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables -q ' select arrayStringConcat((arrayMap(x -> concat(splitByChar('\''/'\'', addressToLine(x))[-1], '\''#'\'', demangle(addressToSymbol(x)) ), trace)), '\'';'\'') AS stack, count(*) AS samples from system.trace_log where trace_type = '\''Memory'\'' group by trace order by samples desc settings allow_introspection_functions = 1 format TabSeparated' + zstd --threads=0 + for trace_type in CPU Memory Real + clickhouse-local --path=/var/lib/clickhouse/ --only-system-tables -q ' select arrayStringConcat((arrayMap(x -> concat(splitByChar('\''/'\'', addressToLine(x))[-1], '\''#'\'', demangle(addressToSymbol(x)) ), trace)), '\'';'\'') AS stack, count(*) AS samples from system.trace_log where trace_type = '\''Real'\'' group by trace order by samples desc settings allow_introspection_functions = 1 format TabSeparated' + zstd --threads=0 + rm /var/log/clickhouse-server/clickhouse-server.log + mv /var/log/clickhouse-server/stderr.log /test_output/ + [[ -n '' ]] + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + [[ -n '' ]]